I am using SQL Server 6.5 and I have to move all the databases from one
server to another.
I have already created the new database devices and the databases on the
What is the best way to do this?
1. Backup all the databases from the old server and restore them on the
new server? Should I also backup the master, msdb and model databases?
What about the user logins? Will I have to re-create them on the new
2. Use the Enterprise Manager and 'Transfer' the databases from one
server to another? What sequence should I follow? I mean, master first,
msdb second, etc.?
Your responce is greatly appreciated.