x

Restore database from Logshipping

When I need to use the secondary database after log shipping do I restore from the last log and recover it? or use the command RESTORE DATABASE database_name WITH RECOVERY

more ▼

asked Nov 13, 2012 at 03:05 PM in Default

avatar image

chitrarekha.saha
686 38 48 57

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

2 answers: sort voted first

Typically you have log shipping setup with a load delay. You would want to roll the database forward to as soon as possible before the problem that occurred that caused you to fail over. If you are simply failing over to do maintenance on the primary then you want all transactions, so apply those logs and do a final WITH RECOVERY restore. If you had a data related event that you want to stop at a specific time, then restore the logs to that point in time then restore WITH RECOVERY.

more ▼

answered Nov 13, 2012 at 04:11 PM

avatar image

Tim
40.9k 39 95 168

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

If you need it to be up to the second then you will need to restore the next log with recovery, if you can skip the tail of the log or are not bothered about the next log being shipped over, you can just restore the database with recovery as you have previously stated.

more ▼

answered Nov 13, 2012 at 03:14 PM

avatar image

anthony.green
3.1k 1 4 6

Plain and simple... what is your Recovery Point Objective? Can you afford to lose the data that would have been in the extra log or is what is already shipped enough?

Nov 13, 2012 at 03:34 PM Blackhawk-17
(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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2221
x86

asked: Nov 13, 2012 at 03:05 PM

Seen: 587 times

Last Updated: Nov 13, 2012 at 04:11 PM

Copyright 2018 Redgate Software. Privacy Policy