Advertisement
- Home
- Microsoft
- Development
- MS SQL Server
- SQL Server 2005
- Could not allocate space because primary filegroup is full error
Advertisement
- 1. chapmandew 2,035,326
- 2. angelIII 1,369,238
- 3. aneeshatti... 513,981
- 4. mark_wills 473,116
- 5. ee_rlee 313,995
- 6. brejk 226,005
- 7. dtodd 209,505
- 8. momi_sa... 177,049
- 9. acperkins 173,863
- 10. rickchild 167,940
- 11. ptjcb 160,219
- 12. Thomasian 155,142
- 13. EugeneZ 143,750
- 14. BrandonG... 143,655
- 15. sbagireddi 136,982
- 16. dportas 125,215
- 17. ScottPletc... 123,615
- 18. jgv 115,921
- 19. appari 114,604
- 20. PFrog 113,160
- 21. DanielWilson 106,114
- 22. chrismc 105,889
- 23. PedroCGD 104,345
- 24. tedbilly 103,765
- 25. bashka_... 98,724
- 1. angelIII 2,649,429
- 2. chapmandew 2,035,326
- 3. aneeshatti... 1,079,086
- 4. ptjcb 525,611
- 5. Yveau 517,373
- 6. mark_wills 473,116
- 7. dtodd 420,510
- 8. PFrog 383,188
- 9. dqmq 368,078
- 10. appari 350,751
- 11. imitchie 333,350
- 12. ee_rlee 313,995
- 13. acperkins 269,202
- 14. ScottPletc... 227,282
- 15. brejk 226,005
- 16. Lowfatsp... 223,289
- 17. matthews... 203,352
- 18. rboyd56 196,590
- 19. SQL_SE... 190,215
- 20. EugeneZ 180,459
- 21. momi_sa... 178,749
- 22. gbshahaq 177,810
- 23. tedbilly 172,104
- 24. DanielWilson 171,904
- 25. dportas 169,180
| 04.27.2008 at 03:11PM PDT, ID: 23357434 |
|
[x]
Attachment Details
|
||
Could not allocate space because primary filegroup is full error
Asked by barnesco in SQL Server 2005
When I attempt to optimize a database, I keep receiving the below error message in my error logs despite that I've shrink the data and log files:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'AUDIT_LOG' in database 'MOEDMS' because the 'PRIMARY' filegroup is full.
The primary data file size is 99mb of 150mb allocated. The log file size is 29mb of 200mb allocated. The file sizes are restricted. This is not by choice, but what the customer wants.
The code I used to shrink the log and data files is below with the results in the attachment. The first result is the log file.
USE MASTER
BACKUP LOG MOEDMS WITH TRUNCATE_ONLY
GO
USE MOEDMS
DBCC SHRINKFILE (MOEDMS_Log, 1)
GO
USE MOEDMS
DBCC SHRINKFILE (MOEDMS, 1)
GO
Why am I receiving this error and how can I fix? Thanks.Start Free Trial
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'AUDIT_LOG' in database 'MOEDMS' because the 'PRIMARY' filegroup is full.
The primary data file size is 99mb of 150mb allocated. The log file size is 29mb of 200mb allocated. The file sizes are restricted. This is not by choice, but what the customer wants.
The code I used to shrink the log and data files is below with the results in the attachment. The first result is the log file.
USE MASTER
BACKUP LOG MOEDMS WITH TRUNCATE_ONLY
GO
USE MOEDMS
DBCC SHRINKFILE (MOEDMS_Log, 1)
GO
USE MOEDMS
DBCC SHRINKFILE (MOEDMS, 1)
GO
Why am I receiving this error and how can I fix? Thanks.Start Free Trial
Attachments:
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628
