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 |
|
r.amutha
Starting Member
6 Posts |
 Posted - 2009-03-16 : 01:41:22
|
| SCENARIO Monday at 2 AM - Full backup and then Everyday 9PM -Differential backup and thenevery ½ hour- Transactional log backup in that time, on Wednesday at 11.45 AM the Server Crash(sql server 2005 express edition).How will you restore the data files up to 11.45AM ?i can able to restore the data upto 11.30 AM but want to restore the data from 11.30-11.45 AM. If database crash means v can use tail log backup but if server crash means wat to doplz help me |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-03-16 : 12:06:01
|
| If the server's crashed completely and the drive with the log is not available, then that last 15 min of data has been lost. That's why the interval between log backups should be the maximum amount of data you are willing to lose in the case of a disaster.Of course, if there was database mirroring, the mirror DB would contain all the transactions from that last 15 min and there would be no loss at all.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
SCENARIO ABOUT THE SERVER CRASH