Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Could not allocate space for object 'MSmerge_tombstone' in database ' ' because the 'PRIMARY' filegroup is full. Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2008 5:58 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 8:44 AM
Points: 330, Visits: 974
Will any one please help me regarding this.

I am getting the following error, while i try to execute a delete query against a table in a database, i have checked the option of auto shrink, simple recovery model, unsrestriced growth and growth of size in terms of MB , even then i am getting the following error please help me


Could not allocate space for object 'MSmerge_tombstone' in database ' ' because the 'PRIMARY' filegroup is full.
Post #460173
Posted Tuesday, February 26, 2008 6:13 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:06 AM
Points: 1,462, Visits: 3,014
Look at the space on the drive where your PRIMARY filegroup resides, and filespace on drive where the tempdb files reside.

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #460182
Posted Tuesday, February 26, 2008 10:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
In the past I had this issue and increasing the space allocated resolved the issue, also check your disk space.
Uncheck AUTOSHRINK! Autoshrink should not be turned on for any production databases, you do'nt want to have perf problems.
Post #460364
Posted Tuesday, February 26, 2008 10:17 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
I agree with others' inputs. You may also check AutoGrowth for databases in this filegroup.
Post #460370
Posted Tuesday, February 26, 2008 9:51 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 8:44 AM
Points: 330, Visits: 974
Hi Thanks for the reply, i have checked the option autogrowth, couldnt come out of this error. Few more sugestions or tips please
Post #460678
Posted Tuesday, February 26, 2008 11:51 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 8:44 AM
Points: 330, Visits: 974
Hi as per your sugesstion, i checked the space and it is as follows,

Size of HD remaining is 169 GB free and the all the db files stay in the same drive, even after the size free is as mentioned above.



Total Database Size
size 45011.91 MB
Space Avlbl 98.76 MB

.ldf size is 5.44 GB size on disk is 2.45 GB
.mdf file is 38.5 GB size on disk 17.2 GB
Post #460700
Posted Tuesday, February 26, 2008 11:53 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 8:44 AM
Points: 330, Visits: 974
Hi thanks for the reply,

Even i checked with increasing the filegrowth size interms of MB , earlier it was 100 MB and i made it to 200 MB even then it is not working. Can i uncheck the check box of auto shrink is it okay to do that.
Post #460701
Posted Wednesday, February 27, 2008 12:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:09 PM
Points: 40,193, Visits: 36,597
Check the space available and space on disk for the distribution database.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #460704
Posted Wednesday, February 27, 2008 3:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 8:44 AM
Points: 330, Visits: 974
Hi,

I checked the space available in the disk for database and it is as follows:


Total Database Size
size 45011.91 MB
Space Avlbl 98.76 MB

.ldf size is 5.44 GB size on disk is 2.45 GB
.mdf file is 38.5 GB size on disk 17.2 GB
Post #460758
Posted Wednesday, February 27, 2008 4:07 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:09 PM
Points: 40,193, Visits: 36,597
dakshinamurthy (2/26/2008)
Can i uncheck the check box of auto shrink is it okay to do that.


Absolutely. Uncheck it now. Autoshrink should never be enabled on a production server. See here for why - Autoshrink Turn It OFF

Is the distribution db set to auto grow?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #460767
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse