November 27, 2009 at 5:29 am
one of the database of my PRD server is currpted(problem with sysindex)
what i need to do ?
Regards,
Shivrudra W
November 27, 2009 at 5:34 am
shivrudra_2008 (11/27/2009)
one of the database of my PRD server is currpted(problem with sysindex)what i need to do ?
Post the error that you have seen.
I am assuming that you have already run DBCC CHECKDB, can you post the results.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 27, 2009 at 5:53 am
hi,
i dont have error now but i will explain you wht is the issue.
there is consistancy problem with sysindexes
database is up and running but my regular maintanance plan going fail with objects inconsistancy.
Regards,
Shivrudra W
November 27, 2009 at 8:32 am
Please run the following and post the FULL output. There's not enough information in what you've so far posted to make even an educated guess.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
First thing I have to ask. Do you have a clean backup of this database (a backup that doesn't have the corruption)?
p.s. This is not a security question and, since you mention sysindexes, I'm guessing it's SQL 2000. Please can you post in the appropriate forum in the future. Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply