开发者

Insufficient disk space in filegroup 'PRIMARY' - SQL Server 2008

开发者 https://www.devze.com 2023-03-02 20:49 出处:网络
Am getting following error: Msg 1101, Level 17, State 12, Line 1 Could not allocate a new page for database \'CTL\' because of insufficient

Am getting following error:

Msg 1101, Level 17, State 12, Line 1

Could not allocate a new page for database 'CTL' because of insufficient disk space in filegroup 'PRIMARY'. 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.

Properties of Database are as follows:

File Name               Autogrowth
CTL                     By 10 percent, unrestricted growth
CTL_Indexes             By 1 MB, unrestricted growth   

And I got 60 GB of space remaining on the disk.

What would be the iss开发者_运维技巧ue ?


What edition of SQL server is this for? SQL Express has a 2GB limit on database size that is reported in this way.


I faced similar error and solved it by changing file properties as under:

File Name               Autogrowth
CTL                     By 20 percent, unrestricted growth
CTL_Indexes             By 2 MB, unrestricted growth   

Hope this works for you also.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号