Moving to a new server....
-
I am about to move our sql server databases to a new server (hardware). Ideally, I would have both servers running at the same time to do the transfer. However, I would like the new server to have the same name and IP as the old. Can I name the new sql installation a temp name, and rename it to the old name (and IP) after the old is taken down? Will this cause problems with the new SQL installation? Any other tips on this process?
Thanks for any input...
-
Yes, you can do this. After you've renamed the second server at the operating system level, you'll need to perform the steps found in "Renaming a Server" in Books Online. This is, of course, assuming you're not running a clustered SQL Server environment for the new server. Clustered SQL Servers are a totally different species of animal.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
-
May also want to read this, if you have an old version of BOL:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303774
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
-
Speaking of which... latest version of Books Online:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Get it as it corrects a lot of errors and also covers the changes made in SP3.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Do you know if there are any issues installing the new BOL on a SP1 or SP2 version, and then migrating to SP3?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
-
So far as I am aware, the BOL install is completely separate from the SQL Server binaries.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
We did this with very few problems a couple of months back. In addition to renaming the servers, you may also need to re-map your user ID's or you wont be able to edit them or update their permissions on the new server. There's a good Microsoft KB article explaining this at: http://support.microsoft.com/default.aspx?scid=kb;EN-US;246133. I was really stuck the weekend I did this until I found this article. Hope it helps.
My hovercraft is full of eels.
-
Oops - forgot
You'll also want to get your network guys into the loop as well. I think the router tables can freak on some systems if the MAC and IP addresses swap devices and no one tells them to be prepared for this.
My hovercraft is full of eels.
-
Thanks for all the responses! I'm going to take this oppertunity to re-structure the datafiles and user groups, so my plan is to create empty databases on the new server, and DTS just the data from old to new. And, recreate the users, etc... there's only a dozen or so users and a couple hundred gig of data, no stored procs or anything else. So, the only thing coming over from the old server is the data. I was just concerned that, after getting all the data over, taking down the old server and renaming the new as the old name, there would be problems. Thanks again...
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply