March 8, 2006 at 3:58 am
We have a database (source server A) from which we transfer ‘ALL’ data to another database on a different server (destinations server B), this is done by a DTS package. However the Job is failing and the message I get on the error log on server B is
Could not allocate space for object ‘XXXXX' in database 'DB_B' because the 'PRIMARY' filegroup is full.
I have the following settings in the database (server B):
Server B (Destination server)
Data File A
----------------
Space Allocated: 1818
Automatically Grow File: Yes
By Percent: 10
Maximum File Size: Unrestricted File Growth
The hard disk has 40 GB free disk space. The transaction log file has also the same settings.
The following options are set in the database properties:
Recovery Model: Simple
Auto Update Statistics
Auto Shrink
Auto Create Statistics
Server A (source server)
---------------
Data File
Space Allocated: 4337
Automatically Grow File: Yes
By Percent: 10
Maximum File Size: Unrestricted File Growth
The hard disk has 40 GB free disk space. The transaction log file has also the same settings.
The following options are set in the database properties:
Recovery Model: Full
Auto Update Statistics
Auto Shrink
Auto Create Statistics
Will increasing the size of the Primary group help, after it is set to autogrow. If so how can i increase using EM.
Thanks.
March 8, 2006 at 4:57 am
Hi - there was a recent post on this site that might help you. The post is about TempDB but it relates to any DB. The problem seems to be when the current free space plus 1 autogrow is not enough.
PS I would not grow by a percentage - use a fixed amount instead.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=255534
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply