moving sql server to a new server
Posted on 2012-04-09
we are planning to get a new server to replace our current sql server running on windows 2003 standard. Since we will probably be running windows 2008 or 2011 on the new server, what is the best way to move sql data to this new server? I thought of taking backups within sql management studio on current server and then restoring to new server but dont know if there are any gotchas i should be aware of if any in performing this process. We are currently running sql server 2008 on the existing sql server and it is not a domain controller.