I am looking at migrating sql server with 25 databases of total size 7TB to a new machine (better hardware).
All settings (logins/dbmail/proxy/credential/lonked servers), and backup/agent job history needs to be retained.
Due to the above, scripting is not an option as it doesn't preserve history.
Maintenance window is of 3 hours.
I have tried setting up new sql server with same version/Patching, followed by restoring the system dbs and user dbs. But this process (including backup/copy/restore takes 7 hours). Without backups (mdf/ldf copy) takes 15 hours.
Alternate approach using full/diff backups:
- Restore user db with norecovery onto new instance
- During maintenance window backup/restore Differential backup with recovery
- Stop original instance
- Stop new instance and reorganize db files as per the source instance data/log paths
- Restore master, msdb, model
This approach takes about 1 hour since differentials are small sized. I'm unable to find any msdn documentation for moving sql to new hardware. Is there any risk with this approach? Or any alternate solution?
For example- at step 1 I can restore master db rather than at step 5.