T-SQL筆記14_sp_helpdb指令的使用_MSSQL:Could not allocate space for object 'X' in database 'Your Database' because the 'PRIMARY' filegroup is full

 通常出現這錯誤就代表你的DB空間已經滿了

這時無論你怎麼insert都會失敗然後跑出這錯誤

對DB右鍵->屬性->切至檔案後到自動成長/大小上限的[...]按鈕開啟訊息窗

一種方式就是去調整你的DB預設上限

或者調成無限制(以北風資料庫預設設定為例)

你也可以透過系統指令sp_helpdb來查看當前DB狀況

可以看到filegroup 為 primary的size已經達到maxsize就代表空間已滿了

Ref:

ERROR: "Could not allocate space for object 'X' in database 'Your Database' because the 'PRIMARY' filegroup is full"

https://support.managed.com/kb/a132/error-could-not-allocate-space-object-x-database-your-database-because-primary-filegroup-is-full.aspx

[問題]~利用jdbc insert資料DB 卻一直無法insert....

https://social.msdn.microsoft.com/Forums/zh-TW/41cf172d-49d3-45ce-8468-59a9a46bf53b/21839389882103329992jdbc-insert3603926009db?forum=240

Could not allocate space for object dbo.table

https://stackoverflow.com/questions/19114680/could-not-allocate-space-for-object-dbo-table

HOW TO FIX ERROR "COULD NOT ALLOCATE SPACE FOR OBJECT 'X' IN DATABASE"?

https://manage.accuwebhosting.com/knowledgebase/2324/How-to-Fix-Error-Could-not-allocate-space-for-object-andsharp039Xandsharp039-in-database.html

SQL SERVER – Error – Resolution – Could not allocate space for object in database because the filegroup is full

https://blog.sqlauthority.com/2014/03/14/sql-server-error-resolution-could-not-allocate-space-for-object-in-database-because-the-filegroup-is-full/

sp_helpdb (Transact-SQL)

https://docs.microsoft.com/zh-tw/sql/relational-databases/system-stored-procedures/sp-helpdb-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15