开发者

SQL Server Primary file group max size

开发者 https://www.devze.com 2023-01-22 11:30 出处:网络
I have a situation, I am trying to run almost 100 update statement on a table say \'XX\' In SQL Server database. But it is giving me an errortat goes something like this...

I have a situation, I am trying to run almost 100 update statement on a table say 'XX'

In SQL Server database. But it is giving me an error tat goes something like this...

"Could not allocate space for object 'dbo.XX'.'PK_XX_3489AE06' in database 'MYDATABASE' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to th开发者_Python百科e filegroup, or setting autogrowth on for existing files in the filegroup."

Please advice me what to do... Thankx in advance


  1. Check to see if your database has auto growth enabled.

  2. Make sure you have available space on disk where your database file is located.

0

精彩评论

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