question

shrikanth avatar image
shrikanth asked

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?
sql-server-2005backuprestore
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob Farley avatar image Rob Farley commented ·
You should go with Answer B.
2 Likes 2 ·
TimothyAWiseman avatar image
TimothyAWiseman answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob Farley avatar image
Rob Farley answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

basit 1 avatar image
basit 1 answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.