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 |
|
real_pearl
Posting Yak Master
106 Posts |
 Posted - 2004-09-06 : 05:29:36
|
| I was reading about Redo Log files in Oracle. If data is being inserted and the one has power outage, then data is lost, means can not be added to the database. In this case Redo Log files are used to recover that data. If similar happens in SQL Server, how can we recover data? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-06 : 06:18:53
|
| the log file has a checkpoint for committed and non-committed data, if ever there was power outage, the uncommitted data will be committed the next time sql starts.haven't proven this though but this is the idea. |
 |
|
|
real_pearl
Posting Yak Master
106 Posts |
Posted - 2004-09-06 : 06:42:38
|
| ok |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-06 : 22:55:46
|
| That's how it works. The only exception to this is if your disk system has a write cache on it. At that point, it's possible a small amount of data is being stored in cache and hasn't even been written to the logs. You need batter backup so the write cache can write to the transaction logs. At that point, you wouldn't lose any data. If you don't have a battery backup and it just shuts off, you run the risk of losing and even corrupting data. If you don't have batter backup, disable the write cache.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
beglobal
Starting Member
1 Post |
|
|
|
|
|
Data Recovery
Stephany Linares