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 - 2003-12-23 : 08:16:28
|
| Qiu writes "if log file of a database was destroyed due to disk fault,how can i do to restore database run normally without loss of data" |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-12-23 : 08:17:53
|
| Unless you have a differential or transaction log backup just prior to failure, I don't think you can. That is why you need to make sure your log files are on redundant (raid) drives...*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-12-23 : 08:44:18
|
| Try sp_attach_single_file_dbIf that failsSeehttp://www.nigelrivett.net/RecoverCorruptDatabase.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
If Log file was destroyed