Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Move SQL 2000 to new box.

Status
Not open for further replies.

jjjax0330

IS-IT--Management
Aug 15, 2005
76
US
We want to upgrade our existing sql 2000 box to a new faster box. What is the best procedure to do this? We want to keep the same server name because of all links and so on. Thanks, Joe
 
I would set up the new server in parallel. Migrate your user and databases. Then you can test make sure everything works on the new server. When you are ready, rename the old server or take it off-line. Then rename the new server and change the IP address to the old server.

- Paul [batman]
- If at first you don't succeed, find out if the loser gets anything.
 
You also have to make sure to tell SQL about it's new host name.
Code:
exec sp_dropserver 'OldServerName'
go
exec sp_addserver 'NewServerName', 'local'
go
update msdb.dbo.sysjobs
set originating_server = 'NewServerName'
go
--Restart SQL


Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Mr. Denny,

Just to clear myself up. Where do you run the code? From the old box or the new box?

thanks
 
You run that from the new server. I would also use sp_rev_logins to move your login accounts. That way you won't have a problme with database SIDS. you can get that procedure here.

thread962-1342371

- Paul [batman]
- If at first you don't succeed, find out if the loser gets anything.
 
Yep, that looks like the procedure.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top