May 9, 2008 at 5:30 am
Hi All,
I have just one corrupted record on a table: I copied everything else to another table but I can't delete or rename the old one!
Is restoring the whole DB my only way out there?
Any help or suggestion would be much appreciated!
Cheers
May 10, 2008 at 1:13 pm
Are you on 2000 or 2005? Your title says 2000 but you've posted in the 2005-specific forum (there's a 7.0/2000-specific corruption forum too - due to the many differences around corruption)
What is the output from:
DBCC CHECKDB (yourdb) WITH ALL_ERRORMSGS, NO_INFOMSGS
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
May 11, 2008 at 1:21 am
Hi john,
check for foriegn key relationship of the table. and your a DB administrator user.
May 22, 2008 at 6:36 am
what is the error message are you getting?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 22, 2008 at 7:47 am
simple timeouts on every operation involving that record
May 22, 2008 at 10:10 am
Can you post the CHECKDB output I requested so I can see how the record is corrupted? Then I might be able to help you.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply