x
login about faq Site discussion (meta-askssc)

relating back up and recovery

This is my backup scenario
full ---->12:00p.m
differential ----->6:00p.m
differential ----->8:00p.m
server crash ------>9:00p.m
what will I do to bring server online?

more ▼

asked Jan 08 '10 at 02:42 PM in Default

shrikanth gravatar image

shrikanth
8 1 1 1

You should go with Answer B.

Jan 11 '10 at 03:41 AM Rob Farley
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Is this a homework or certification question? Please forgive me if it is not, but it sounds a lot like a question from the MCTS.

Anyway, the first question is do you have log backups and is it in full recovery mode? If so, attempt to do a backup of the remaining log tail, then restore the full, restore the 8:00PM differential, and then restore the log backups.

If not, restore the full and the 8:00pm differential and accept that you have lost all changes from 8:00 - 9:00. Then seriously consider if you can afford that kind of data loss and consider if you need to implement log backups.

more ▼

answered Jan 08 '10 at 03:17 PM

TimothyAWiseman gravatar image

TimothyAWiseman
14.3k 16 20 29

(comments are locked)
10|1200 characters needed characters left

A differential backup includes everything since the last Full backup (that didn't use the COPY_ONLY option). Therefore, any restore sequence will only require at most one differential backup.

more ▼

answered Jan 11 '10 at 03:40 AM

Rob Farley gravatar image

Rob Farley
5.7k 13 17 19

(comments are locked)
10|1200 characters needed characters left

You Can bring your database online till 9 PM if it is is Full Recovery Mode and Apart of this Policy you must also take the log backup.

if you have the Transaction Log back then only you can bring the Server Online. in this scenario you can come up 8 PM.

more ▼

answered Aug 16 '10 at 08:35 PM

basit 1 gravatar image

basit 1
439 36 54 80

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1834
x170
x95

asked: Jan 08 '10 at 02:42 PM

Seen: 945 times

Last Updated: Aug 17 '10 at 12:18 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.