November 16, 2003 at 12:10 pm
Hello,
What would be the correct way of retiring the Old Server and moving all data to the New SQL 2K (having the SAME Name).
Specifically my concern is when to rename Server:
Old Server Name - MyServer -->
Create New Server - MyServerNew -->
Move All data from MyServer to MyServerNew-->
sp_dropserver 'MyServer'--droping old server
I guess before adding new server I have to RENAME the server from MyServerNew to MyServer. How can I do that?
sp_addserver 'MyServer', Local --adding new server
Thanks
ad
November 17, 2003 at 11:25 am
From the OS I will do a backup and restore.
Especially if the location of the datafiles
and log files are the same
Mike
November 17, 2003 at 2:10 pm
Still..
How to rename the SQL Server.
You cannot have 2 servers with SAME NAME on the Network.
Unless.. I place my new server off network, so I could move there all data from the Old Server via backup/Restore.
I take my old Server off the Network and place New Server on the Network.
Any sugestions on that?
ad
November 17, 2003 at 2:32 pm
Barsuk -
It sounds like your last plan is pretty good. Of course, it depends on your having the luxury of taking your database server offline for the duration of the move.
One problem you may run in to is this:
If your database is busy, you may find that the new server is out of date by the time you transfer the server name and ip address to it. What I mean to say is that your old server may still be reciving updates while you are restoring the databases on the new server.
Let us know what you decide to do.
- Dan B
November 17, 2003 at 3:43 pm
At where I am we replace lots of sql servers every year.
.old server name -- myserver--> keep it this way.
.backup myserver and restore it to myserverNew.
.take old server name out of domain and put it into workgroup temporary, reboot.
.take old server name and put it to join domain with a new name like myserver_old, reboot.
.take myservernew out of domain and put it into workgroup, reboot.
.take myservernew and put it join domain with a new name my myserver, reboot.
However you still need to change your local to point to myserver. I think you could drop your local and add the new name back.
everything should works fine and smooth. The whole process of changing server name should take about a couple of minutes.
It is good to plan and try database refresh a couple of time before you plan for the real thing.
good luck. mom.
November 17, 2003 at 9:34 pm
Thanks,
I think that the best time to do that is at night.
Also what would be the T-SQL command for renaming the server.
ad
November 18, 2003 at 9:24 am
We rename the NT server not SQL Server... sorry no sql command for that.
mom
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply