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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-07-07 : 03:43:35
|
| Hi all I tried this commandDBCC CHECKDB (A2PD,REPAIR_ALLOW_DATA_LOSS)The above command was not executed as there was some long rollback was going from a user...I stopped and re started the MSSQLSERVR service...Then i found the follwing error..how can i work with the database A2PD marked as suspectServer: Msg 926, Level 14, State 1, Line 1Database 'A2PD' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-07 : 03:58:00
|
| i believe you were advised not to run the repair,or do anything rash like... restarting the services?anyways, your topic on data corruption is now on the right forumatleast it's not production...as a tip, when a database is still recovering, you should wait it out until it fully recovers--------------------keeping it simple... |
 |
|
|
|
|
|
database marked as suspect