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 |
|
nomadnate
Starting Member
3 Posts |
 Posted - 2009-06-26 : 13:51:53
|
| Hi,I'm wondering if someone can enlighten me on what happens with SQL and its transactions in the event of an OS crash or a power outage?On a hardware platform, if a crash takes place, what needs to be in place to ensure that no data is lost?I'm guessing that the data goes to the drive array cache and is recovered once the OS is back in line and SQL is reinitialized? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-26 : 14:18:52
|
Most of it. SQL Server analyzes the log file and recreates all events up to the time of the crash.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
nomadnate
Starting Member
3 Posts |
Posted - 2009-06-29 : 14:53:44
|
| Thanks, I'm new to SQL administration and recovery so bear with me.So depending on your Recovery Model (ours are typically Simple), you can only recover back to your last BAK file -- where as Full Recovery Mode would let you recover back to the last transaction in your LDF (Transaction logs)? |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-06-30 : 10:09:37
|
| Simple mode - last full backup. Full recovery, provided your are doing log backups, it's to the point in time (or earlier) of your last t-log backup. Check BOL for backup/restore, there is some good info there (or Goggle, or search this site, etc....).Terry-- Procrastinate now! |
|
|
|
|
|
|
SQL Server disk writes and OS crashing