Q:  Hi I have one sql server 2000 containing 10 databases, around 100 jobs, the os being windows 2000 server. I have to migrate to a new server having os as windows 2003 please give a plan for the migration with the least downtime so that everything on the current server is moved on to the new server.

Dave Swanson says:   This is a tricky process that requires a comprehensive plan including everything from hardware configuration, complete backup of each database (user and system), DNS/IP configuration, application changes (possibly) and migration of your windows file system. While I understand your drive to decrease downtime I feel it is much more important to verify the migration is done correctly (dot those i’s, cross those t’s).

Edgewood Solutions created a very useful template for migration that is a great place to start.

Not to promote *too much :)*, if you want to complete the backup and recovery part of the migration, try taking a look at LiteSpeed for SQL Server

Technorati tags:
SQL+Server migration migration+plan Edgewood+Solutions backup+and+restore