Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Filegroupe Space

Author  Topic 

rohaandba
Starting Member

33 Posts

Posted - 2012-06-25 : 20:15:20
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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-25 : 20:34:10
Seems you are out of disk space to do it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rohaandba
Starting Member

33 Posts

Posted - 2012-06-25 : 20:41:09
Actually all the drives have more than 20 GB free space


quote:
Originally posted by tkizer

Seems you are out of disk space to do it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-25 : 20:46:03
Then your file is set not to autogrow or you need more than 20GB of free space.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -