October 20, 2008 at 5:58 am
If my database has been crashed/corrupted at Wednesday 1Pm and I have the following backup's scheduled on that database:
1. Every sunday night at 10PM -Full db backup.
2. Monday - saturday night at 10PM - Diff db backup
3. Transaction log backup - Every day every 30 minutes.
since the database was crashed/corrupted at Wednesday 1Pm, so can I restore the following way:
1. First apply the Full db backup from sunday night.
2. Next, apply the diff db backup from tuesday night 10PM
3. Then apply all the transaction log backup's from Tuesday 10.30Pm thru wednesday 12.30PM. While applying the transaction log backup's, I shall leave the db non-operational and t-log backup's can be stored except on the last t-log backup. When I apply the last t-log backup, I shall leave the db operational with no t-log's restore.
Please let me know if the above procedure is correct while restoring the crashed/corrupted database.
Thanks much!!
October 20, 2008 at 7:37 am
Looks good to me. The only question I have is do you have the Wednesday 1 pm log backup? If you do you could potentially do a point in time restore of that in order to reduce lost data.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 20, 2008 at 9:36 am
Jack Corbett (10/20/2008)
Looks good to me. The only question I have is do you have the Wednesday 1 pm log backup? If you do you could potentially do a point in time restore of that in order to reduce lost data.
No I do'nt have wed 1pm log backup, it errored out. So, what can I do in order to get the data that has been entered in the system from wednesday 12.31PM to 1PM duration? Thanks for the reply.
October 20, 2008 at 9:43 am
If you cannot get a log backup from the current log then as far as I know you cannot get the data from 12:30 to 1:00. It will need to be re-entered or left missing. This is why you need to know what is an acceptable amount of data loss when scheduling log backups. If 30 minutes is fine then do them at 30 minutes if not then you may want to go to every 15 and add at least one differential during the day.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 20, 2008 at 9:45 am
What's the status of the corrupted DB? Can you connect to it and run a tail log backup?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply