• Noel McKinney (6/18/2009)


    Good article Jonathan, I've used these steps to move databases to new hardware and datacenter with just a few minutes of downtime. The key is making sure that the application(s) that use the databases are good to go. If possible you need to test such applications on the new hardware first to make sure the configurations are set properly... restore a backup of an actual database for such testing, using a "test" database might not reveal potential problems.

    The other thing is to make sure that logins have been propagated to the new server.

    The sp_help_revlogin stored proc could be useful for moving the logins.

    edited to add URL:

    http://support.microsoft.com/kb/246133

    Gethyn Elliswww.gethynellis.com