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 - 2004-09-15 : 08:50:34
|
| Nilesh writes "The problem is due to some electrical problem or system down problem my databast went into a 'suspect' mode where i was not able to access any of my tables or any data.After going through the Server log i cam to know that the log file is corrupt:Even the i tried following command like:1. sp_resetstatus BookDB2. sp_attach_db &sp_detach_db for BookDB3. sp_add_log_file_recover_suspect_db with BooDB as my database.I thought atlease it will work with the last one. But it didn't.And i had to restore databackup of 5 days back.Do you know anyother solution with which i can recover data from corrupt log file.Thanking you." |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-09-15 : 11:53:20
|
when you get a problem with the database say it crashes. Backup the T-Log there and then using the NO_TRUNCATE option... That way you can roll back the transactions to a single instance before it became unstable. Dont forget to lock everyone out while you do this  have fun! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-15 : 13:59:31
|
| Do you have a full backup to recover with? What is your database recovery model set to? If FULL, do you have tlog backups?Tara |
|
|
|
|
|
|
Solution to Recover 'Suspect' Database back to Normal