Restore chain
-
Hi all,
Need some help to clarify restore procedure using full-differential-trlogs backups. My script (for every type of restore) is working fine but now I have a concern how to connect everything in restore chain. I mean, let say, I started full restore and it will take 4 hours. Do I really need to wait 4 hours until I can start differential backup? Do I need to check error code (probably, yes, and how to do this) after full restore and before starting next one? (same questions regarding transaction logs restore). What is a common practice to join all restores- put them in one transaction or another ways?
Thanks in advance
-
Do I really need to wait 4 hours until I can start differential backup? Yes
Do I need to check error code (probably, yes, and how to do this) after full restore and before starting next one? In fact that goes for each restore(-type)
1) restore latest full backup with norecovery
2) restore latest diff backup with norecovery
3) restore all log-backups (in sequence ii ) produced after the latest diff-backup. all with norecovery except the last one use with recovery
You db will be unavailable during restore untill you set the with recovery option.
SQL2005 (still in beta2) has earlyer availabillity
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
-
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply