August 5, 2002 at 8:34 am
Hi,
I want to restore the master database from an old test server to a new one. The old server name was 'oldserver' and the new servers name is 'newserver'. When restoring the oldserver.master database to newserver, everything goes fine, I restore when the services are started in single-user mode. But then the whole server crashes and I cannot access SQL Server. Do I need to use the sp_addserver and sp_dropserver sprocs to adjust the SQL Server name in the master database? Is this what is causing the problem?
Thanks in Advance
August 5, 2002 at 8:39 am
Here's an article about moving system databases from one server to another:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q304692
Typically, when SQL Server goes down it write information to its log files and/or the event log. Is the actual error captured there?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
August 5, 2002 at 8:49 am
Hi Brian,
Thanks for the quick response. I checked out the article. I will go through the steps and try it out. I am thinking though that it is just moving the files. Does the actual name of the server have any effect on the restoration of the master database to a server with a different name? In other words, I feel like I should also adjust the server name in the master database anyway. I thought this is done using the sp_dropserver and sp_addserver sprocs? I guess I'm just paranoid. I will go with the article first and see what happens.
Thanks,
brice
August 5, 2002 at 8:56 am
SQL Server will run even if the servername in the master database differs from the actual name of the server. There was a development server running for months where I work that hadn't been renamed. It was a sandbox for one of the DBAs and he never thought to do it, but he never ran into any conflicts. Eventually, though, he did rename the server.
So that's not likely the cause of the problem. However, when the problem is resolved, you'll probably want to rename it.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
August 5, 2002 at 9:22 am
sp_dropserver
sp_Addserver <new name>,local
will rename the server
Steve Jones
August 6, 2002 at 9:29 am
It looks as though the article that you pointed me to worked. Thanks for all your help. I really appreciate it.
brice
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply