Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup Question

Status
Not open for further replies.

qsac

Programmer
Jan 22, 2002
242
US
All

Just a quesion. Migrating a Database from Server A to Server B.

The task is the same at the beginning. Full backup on A, restore on B with no recovery. Now i am trying to sync the t-log.

Do you see any difference between these 2 approaches.

1. Set the database on A to Read Only, Backup T-Log on A, restore T-Log on B
-- OR --
2. Backup "Tail" of T-log on A and restore to B

Thoughts?

 
I think that the important thing is to set the database on server A in read-only mode before you take the final backup. The final backup could be a full backup (the easiest way), a differential backup or a transaction log backup.

Ola Hallengren
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top