Error Message

Could not allocate space for object
'dbo.ABC_XYZ_XYZ'.'AB__ABC_XYZ__XYZ' in database 'ABC' because
the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded
files, dropping objects in the filegroup, adding additional files to the
filegroup, or setting autogrowth on for existing files in the filegroup.

Solution



Please follow below steps to Increase Database disk space allocation from SQL server management studio.
  1. Login to SQL Server Management studio with sa user.
  2. Expand databases tab.
  3. Right click on database and click on Properties.
  4. Go to Files tab.
  5. Click on Browse button for Autogrowth option.
  6. Increase size as per your requirement in Maximum file size >> Restrict File Growth option.