Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Could Not Allocate Space for Object... because the 'PRIMARY' filegroup is full

Today lots of messages were getting Suspended in the production env and to find the exact reason for this sudden messages getting suspended, looked into the Event Log and found below two errors:


 
 


Why it happened:

As can be interpreted from error message, the allocated space for Biztalkmsgboxdb was full.


What to do:

The first thing was to check if AutoGrowth is enabled or not on BizTalkMsgBoxDb, and it was.
 
Then had a look at the jobs and found that DTA Purge and Archive Job was disabled since a week (don't know how) and that was the reason for this issue. So to fix the issue, reconfigured the job and enabled it and also purged the Tracking database.
'); }());


This post first appeared on TechFindings, please read the originial post: here

Share the post

Could Not Allocate Space for Object... because the 'PRIMARY' filegroup is full

×

Subscribe to Techfindings

Get updates delivered right to your inbox!

Thank you for your subscription

×