July 22, 2008 at 2:24 pm
My DTS failed due to the following error message
Could not allocate space for object in database 'ABC' because the 'PRIMARY' filegroup is full..
please see the out put of "sp_helpdb 'ABC' "
name
ABC
db_size
5882.63 MB
owner
USER_ABC
dbid
10
status
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoShrink, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
compatibility_level
80
July 22, 2008 at 2:53 pm
Check if there is any limit to the auto-growth of the data files
configured?
If they are then run the below and try again (I see the table is set auto update still you can give it a try)
DBCC updatestats.
Apart from that can you tell how many records you are processing with this DTS
July 23, 2008 at 7:59 am
Check the auto-grow feature AND if auto-grow is enabled, check the available disk space on the drive where your primary file resides. You're running out of space for some reason. Also, turn off auto-shrink. That's definitely not considered "best practice" and will do more harm than good. Constant shrinking and then growing will lead to file-level fragmentation. If autoshrink is on and autogrow is off, this would eventually lead to the condition you're seeing.
-- You can't be late until you show up.
July 23, 2008 at 8:09 am
If you have other filegroups, you can also move the table to the other filegroup or set the other as the default.
Do not shrink the database regularly.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply