WARNING: I am an EXTREME NEWBIE to MS SQL.
I have been assigned a project to move the entire SQL Server over to a new server that will have the same computer name as the current SQL Server.
I found a couple different sites that instruct you to simply stop services and copy over data(Folder's with security/shares+permissions) to the new server. Then take the old server off of the domain, and rename the new server to the name of the old server. Check the name of the new server in SQL using the @@Server command and whola!
Will this work in my situation? Is it really that easy?
This is the environment:
Old Server: Windows Server 2003 32-bit MS SQL 2005 SP3
New Server: Windows Server 2008 64-bit MS SQL 2005 SP3
I have gone through SQL Server Configuration Manager and SQL Server Surface Area Configuration Manager and matched up all of the settings. I have also matched the physical drives to match the existing server, except they are larger on the new server.
What kind of surprises may I see during this move? Should I avoid this plan and use something else like detaching/attaching? Are all of the logins going to work?
Again... I am very new to administering SQL... so excuse my lack of knowledge while writing this question.