I want to migrate production DBs from one server to a different one.
This is my plan:
- Shut down the application
- Change the DB to single user mode
- Take a full backup for all databases
- Restore the backup to the New server and remap logins
- Create replication
- Point the application to the new server
- Start the application
This may take 4 hours to complete. Is there a way I can perform this in less time? It is kind of hard to request 4 hours down time.