June 10, 2009 at 1:09 am
I am taking weekly full backup on Sunday, every day differential backup and every one Hour transactional backup, if sql server crashes on Friday 8:15 pm? Explain the steps to Restore the data base
please some one help me how best can we address for this question 🙂
June 10, 2009 at 1:29 am
Hmm ... Books online is a good resource to figure this out.
But anyways...
If you can, create a last Log backup !
then:
hmm ...
1) restore the latest FULL backup with NOrecovery
2) restore the latest DIFF backup with NOrecovery
3) restore the LOG backups that contain the log sequences to continue you restored DIFF. (May be multiple restores)
Restore as much as you need (using with NOrecovery )
and only perform the restore database with recovery if you know you are done.
If you need a point in time restore, you use the stopat=datetime with recovery
SQLServer will generate a warning if the PIT is not reached with that individual log restore and will leave the db in recovery mode.
TEST IT before you need it !!!!
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 10, 2009 at 1:54 am
that ia a great answer thank you 🙂
June 10, 2009 at 5:25 am
Chinna (6/10/2009)
I am taking weekly full backup on Sunday, every day differential backup and every one Hour transactional backup, if sql server crashes on Friday 8:15 pm? Explain the steps to Restore the data baseplease some one help me how best can we address for this question 🙂
It sounds like an interview questioin 😛
Anyways,
1.) If the database is accessible backup the active portion of the log ( tail log backup)
2.) Restore your recet Full backup ( Sunday) WITH NO RECOVERY
3.) Restore your recent Differential backup ( Friday differential, assuming you took this at am) WITH NO RECOVERY
4.) Restore all tlog backups after differential backup till 8pm with NO RECOVERY
5.) Restore the tail log backup WITH RECOVERY
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply