July 9, 2013 at 2:36 pm
I hope this is not a silly question, I will first give some background...
I am heading a project to migrate databases from one data center to another data center that are geographically not close to each other. Instead of copy a large database file across a WAN the day of, I would like to get the work done ahead of time with Log Shipping and on the day of backup my last tran log, restore it to the new server, and then recover the databases. On the primary server, I plan to make sure that no one is connected and there are no running transactions using sp_who2, DBCC opentran, or any other method someone would like to suggest.
So my question is, how can I be 100% for sure that I in fact have the last Tran Log backup so that I can restore it and recover the databases on the server?
Like I mentioned previously, I hope this is not a silly a question and I do appreciate any and all feedback.
Thank You
July 9, 2013 at 4:13 pm
No, it is not a silly question. But to be sure that you have the very last log backup, you should put the database in single-user mode before you take that log backup.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 10, 2013 at 6:16 am
Thank You Erland...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply