<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
Administration
»
Could not allocate space for object...
12 posts, Page 1 of 2
1
2
»»
Could not allocate space for object 'MSmerge_tombstone' in database ' ' because the 'PRIMARY' filegroup is full.
Rate Topic
Display Mode
Topic Options
Author
Message
dakshinamurthy-655138
dakshinamurthy-655138
Posted Tuesday, February 26, 2008 5:58 AM
Old Hand
Group: General Forum Members
Last Login: Today @ 3:27 AM
Points: 327,
Visits: 872
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
Carolyn Richardson
Carolyn Richardson
Posted Tuesday, February 26, 2008 6:13 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:52 AM
Points: 1,397,
Visits: 2,738
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
Mh-397891
Mh-397891
Posted Tuesday, February 26, 2008 10:03 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:28 PM
Points: 261,
Visits: 1,492
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
SQL ORACLE
SQL ORACLE
Posted Tuesday, February 26, 2008 10:17 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Friday, April 05, 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
dakshinamurthy-655138
dakshinamurthy-655138
Posted Tuesday, February 26, 2008 9:51 PM
Old Hand
Group: General Forum Members
Last Login: Today @ 3:27 AM
Points: 327,
Visits: 872
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
dakshinamurthy-655138
dakshinamurthy-655138
Posted Tuesday, February 26, 2008 11:51 PM
Old Hand
Group: General Forum Members
Last Login: Today @ 3:27 AM
Points: 327,
Visits: 872
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
dakshinamurthy-655138
dakshinamurthy-655138
Posted Tuesday, February 26, 2008 11:53 PM
Old Hand
Group: General Forum Members
Last Login: Today @ 3:27 AM
Points: 327,
Visits: 872
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
GilaMonster
GilaMonster
Posted Wednesday, February 27, 2008 12:01 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 37,658,
Visits: 29,909
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
dakshinamurthy-655138
dakshinamurthy-655138
Posted Wednesday, February 27, 2008 3:35 AM
Old Hand
Group: General Forum Members
Last Login: Today @ 3:27 AM
Points: 327,
Visits: 872
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
GilaMonster
GilaMonster
Posted Wednesday, February 27, 2008 4:07 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 37,658,
Visits: 29,909
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 »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
