June 25, 2012 at 6:09 pm
HI,
I am trying to drip a primary key and Recreate it, But I am getting this error
Msg 1750, Level 16, State 0, Line 3
Could not create constraint. See previous errors.
The statement has been terminated.
Msg 1101, Level 17, State 12, Line 3
Could not allocate a new page for database 'DB_Name' because of insufficient disk space in filegroup 'FileGroup_Name'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Can any help me out how could I resolve this issue on Production Server
Thanks
June 25, 2012 at 8:16 pm
Could you have set your filegroups for "no growth" or "restricted growth" as specified in the error?
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 25, 2012 at 8:18 pm
Please check the space on the drive where your datafiles are located or Database is set to a fixed growth, please increase the valueor change it to autogrowth in MBs or percentage. You can enable it through
Rightclick on DB-->Properties-->General.
Regards
Srikanth Reddy Kundur
June 26, 2012 at 1:59 am
You need between 1.5 and 2.2 times the space to create the constraint, so if your table is 10GB you need between 15GB or 22GB space. You could get around it by sorting in TempDB but then it will still require enough space to place the primary key on the filegroup in the actual database.
As already suggested, check your autogrowth settings, add additional disk space, add additional files to the filegroups, drop objects which are not needed, delete/archive data that is no longer required to release space back into the filegroups.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply