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 |
|
dontipton
Starting Member
8 Posts |
 Posted - 2002-09-04 : 08:58:06
|
| If the hard drive that contains my Transaction log crashes what are my options?Is there a way to get the DB to a consistent state after the crash and create a new tlog on another device?Should I create a new tlog on another device and then restore my latest full backup and roll forward my tlog backups (this assumes a loss of some data is acceptable)?Don |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-04 : 09:01:33
|
| I would go for the latter every time.Your tr log backup schedule should be based on how much data you can afford to lose.Getting later data from the crash depends on being able to dump the tr log.If you need to be able to retrieve transactions in the case of not being able to access the tr log you will need to record them in some other way.==========================================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.Edited by - nr on 09/04/2002 09:03:51 |
 |
|
|
|
|
|
Transaction Log Device Failure