MSSQL Upgrade Best Practice
to replace my aging 3 year old server and need to move 84 various MSSQL databases with minimal or no downtime.
The total size of all databases and transaction logs is about 47Gb, there are 129 user accounts, and various MSSQL Agent tasks that need to be transferred to a new server. Everything is ready for a big day, all I need is to figure out how to move all these database's and users without disrupting any services that rely on them. I was thinking of doing detach/copy/attach routine, but that means hours of downtime. Is there any other way to have new server run in the slave mode to synchronize all the data and users with master server (old box server) and then later simply switch DNS.
I'm looking forward for any suggestions regarding this issue, thanks.
