Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Suspect Database
Thanks, this will help. The problem right now is that when I restart the database after changing the state it is marked suspect again. Is there a way to start SQL without running the automatic recovery? I can't find an option for that! Thanks! Troy Marshall- optix
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Suspect Database
I have tried to reset status and this does not work. When I bring the database back up it is marked suspect again. I am trying to get it up long enough to do a BCP or DUMP. The error appears to be with sysindexes. I recieve an error: Unable to find row in sysindexes for clustered indexes on...- optix
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Suspect Database
I have a situation where a clients DB has been marked 'SUSPECT'. It appears that their (ex)DBA failed to backup the DB properly. Everything that I have tried has failed to bring back the DB. Here is the error: Unable to find row in Sysindexes for clustered index on system catalog 1 in database...- optix
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
