Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
logie0726
Starting Member
17 Posts |
 Posted - 2008-09-02 : 00:08:31
|
 Can someone help me resolve the problem. My Database was on a SUSPECT status due to the power interruption! We tried the following command "sp_resetstatus 'databasename'" to resolve the issue but still on SUSPECT status...(****A database can be marked suspect for one of the following reasons (this is from SQL Server Books Online):If one or more database files are not available. If the entire database is not available. If one or more database files are corrupted. If a database resource is being held by the operating system)After no luck in restoring the database. We detached the database but we cannot rettach it again! Any idea... ALTHOUGH WE HAVE BACKUP, IT IS MORE IMPORTANT FOR US TO RESTORE THE ORIGINAL DATABASE! THANKS... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-02 : 01:05:12
|
| Open a case with Microsoft to get this resolved quickly.Or you can wait for us to respond here and for us to ask lots of questions.1. What error did you get on the restore?2. Are the database files on disk still?3. Are there errors in Event Viewer that need resolving?4. Why did you detach the database?5. Do you have transaction log backups, the entire tlog backup chain since your newest full backup?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-09-02 : 02:41:31
|
| What's the error that you're getting trying to reattach?The best and recommended way of solving corruption problems is to restore the backup (and the log backups, assuming you have log backups). If the database is suspect, getting it usable will very likely involve some data loss--Gail ShawSQL Server MVP |
|
|
|
|
|
|
DATABASE SUSPECT STATUS DUE TO POWER INTERRUPTION