Home Forums SQL Server 2008 SQL Server 2008 High Availability Using High Availability to move to a new server? RE: Using High Availability to move to a new server?

  • September 10, 2012 at 11:02 am

    #1535827

    sql-lover (9/8/2012)

    I do not believe it is possible for you to move the server objects (SSIS packages, customized jobs, etc) but you may re-create those (prior migration) and test. Actually, I am assuming you will test the migration anyway.

    But yes, the databases can be migrated quickly using Mirroring.

    I did it recently with several big databases and found no issues and it was to move from SQL2005 to SQL2008. The key is, ensure you have the same users on the other servers and you already reset the SSID. Once done, it takes a few seconds.

    Thanks for the responce.

    After some more research and testing I will be using mirroring. Clustering is out of the question, due to the servers being ver 2003 and 2008.

    Mirroring is working very well!