Home > IT Answers > Database > Move/Copy System DB’s to new server in SQL 2005
Seandon
5 pts.
 Move/Copy System DB’s to new server in SQL 2005
Database migration, SQL, SQL 2005, Virtual Servers
Trying to move system DB's to brand new server (really virtualized server). Server names are different. Any suggestions would be appreciated.

Software/Hardware used:
ASKED: August 4, 2008  5:12 PM
UPDATED: August 4, 2008  7:54 PM
RELATED QUESTIONS
Answer Wiki:
Bring up the SQL Server into single user mode and restore the master database. <pre>From the command prompt find the folder that the sqlservr.exe is in and run it with the -c and -m switches. Leave the command prompt open as SQL Server is running in this window for now.</pre> Then use the sp_dropserver / sp_addserver commands as if you were renaming the SQL Server. <pre>exec sp_dropserver 'OldServerName' exec sp_addserver 'NewServerName', 'local'</pre> You can then restore the msdb database if needed. If all you have is a few jobs, just script them out and create them on the new server.
Last Wiki Answer Submitted:  August 4, 2008  7:54 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.