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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-25 : 08:57:31
|
| Nathan writes "One of my databases became a suspect database and I followed the steps listed in this site and BOL (sp_resetstatus...),rebooted the server but when it was about 29% in the recovery stage, I got a message saying recovery stopped for the reason being my transaction log for the database was corrupt.Can someone help me resolve as even though I have a good backup and I am being asked not to overwrite." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-25 : 10:33:44
|
| Corruption is a very serious issue. I would call Microsoft Product Support. However, the easiest way to recover will be to restore your backup.You may also want to try sp_attach_single_file-Chad |
 |
|
|
|
|
|
suspect database with corrupt log