Move SQL 2005 to new server
Posted on 2010-11-08
We are upgrading the hardware on our SQL server, and I'm needing to know the quickest way to move the databases/instaces from one machine to the other. The old machine is 2003 Standard 32bit and the new one is 2008 R2 64bit. The SQL server is currently 2005 32bit, but it will be installed on the new server as 2005 64bit.
What is the best way to go about doing this. I was going to just install SQL 2005 64 bit on the new server (both instances). Then just do full backups and restores from the old server. Rename the machines and be done.
That will get my data there, but what about all the other stuff, like users, maintenance jobs, ....?
I have about 20 small databases spanning 2 instances with no replication. Any guidance would be appreciated.