Migrating Systems - Advice Needed

• csoloway

  Ten Centuries

  Points: 1087

  More actions

  March 28, 2007 at 6:48 am

  #123259

  I am to be involved in moving 3 clusters soon from one data center in the Northeast to Texas.   The main requirement is to have the shortest cutover period possible.

  System 1 - 64-bit SQL Server 2000 SP4 to a like environment.   I see no issue with that one.  Stage the new server, restore a backup and put it in log shipping or use a product like Double-Take to keep things in sync.

  System 2 - 32-bit SQL Server 2000 SP3a to 64-bit SQL Server 2000 SP4.  This instance has over 200 databases on it.    Don't think log shipping is an option here.  It's not indexed well enough for replication and because the environments aren't like I don't think Double-Take will work.  Ideas?

  System 3 - 32-bit SQL Server 7 SP4 to a 64-bit SQL Server 2000 SP4.  The SQL 7 cluster is currently on Windows NT.   Same scenario as System 2.

  Ideas?  

• Carlos Pereyra

  Ten Centuries

  Points: 1069

  More actions

  March 28, 2007 at 10:51 am

  #697485

  Offhand, I think I would approach it like this:

  make sure all databases are in full recovery mode

  create a script which will backup all the databases

  something like 'select dump ' + name + ' to disk ....

  create a script that willl load all databases and leave them in the norecovery state.

  load the db's into the new server.

  script dumping the logs for each database

  script loading the logs and recovering the databases

  etc.

   

  ---

  Regards,

  Carlos