Moving a DB mirror to new server

• jimk-524058

  SSC Veteran

  Points: 235

  More actions

  June 1, 2010 at 11:57 am

  #222142

  I have a SQL Server 2005 instance (I'll call Principal) mirroring to one location (Target1) that I want to move to a different location (Target2). The data files are too large to backup Principal and copy over to Target2, but Target1 and Target2 are in the same network and transfers between them are easy. Is there any way to stop the mirror going to Target1 and just move the data files over to Target2 and somehow reestablish the mirror? Everything I've tried so far has failed.

  Thanks for any help.

• Mark Shepherd-435962

  Mr or Mrs. 500

  Points: 568

  More actions

  June 3, 2010 at 2:12 am

  #1175741

  I haven't tried this, but you could try

  1/ Suspend mirroring and Transaction log backups

  2/ Take snapshot on Target 1

  3/ Backup snapshot on Target 1

  4/ Restore snapshot on Target 2 with no recovery

  5/ Transaction log backup on Primary

  6/ Restore Transaction log backup on Target 2 with no recovery

  7/ Set up mirroring from primary to target 2

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  June 3, 2010 at 4:18 pm

  #1176236

  duplicate. No further replies here please. see -

  http://www.sqlservercentral.com/Forums/Topic930909-291-1.aspx#bm931000

  ---------------------------------------------------------------------