March 20, 2008 at 3:36 am
My sql 2000 database is showing in suspect mode
Please suggest on this
vrijesh
March 20, 2008 at 4:36 am
SQL Server database will be marked as 'Suspect' if the permissions for database files are missing. Also if the database files are being accessed by some other process while SQL Server startup it will be marked as 'Suspect'. You need to detach and reattach the database to bring the database online
[font="Verdana"]- Deepak[/font]
March 21, 2008 at 12:23 pm
I could be wrong here but I would think you want to try and get any critical data exported out from the database before you detach it because there is a chance you will not be able to attach it again if it is corrupt. If the corruption, torn page for instance, is just in one table you might be able to save other tables. If that's not possible a restore might be your best bet. I would like to hear from other people on this.
Thanks.
March 21, 2008 at 2:06 pm
Are there any errors in the error log?
Without knowing more about why SQL's marked the database suspect, it's impossible to suggest an appropriate course of action.
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