473,326 Members | 2,128 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Moving SQL DB's from machine to another with the same name

hello everyone. i am new to the group so i aplogize if this question has
been answered recently...

our sql db machine is too old. we bought a new server with which to replace
it. the trick is, we want to keep the name of the machine and db instance
the same.

obviously, we don't plan on having two machine with the same name on the
network at the same time. how do we handle this?

my first thought is to name the new machine with a new name (mach2),
transfer over all the db's, take the old one (mach1) off of the network.
rename the machine/instance to the old one (mach1).

if i do this, can i drop the original instance on the new machine
(mach2)-->register the new (mach1)? will my data be there?
Thanks so much for any relplies!!!
Jul 20 '05 #1
2 3102
Go Browns! (go@browns.com) writes:
hello everyone. i am new to the group so i aplogize if this question has
been answered recently...

our sql db machine is too old. we bought a new server with which to
replace it. the trick is, we want to keep the name of the machine and
db instance the same.

obviously, we don't plan on having two machine with the same name on the
network at the same time. how do we handle this?

my first thought is to name the new machine with a new name (mach2),
transfer over all the db's, take the old one (mach1) off of the network.
rename the machine/instance to the old one (mach1).

if i do this, can i drop the original instance on the new machine
(mach2)-->register the new (mach1)? will my data be there?


This KB article gives some good advice
http://support.microsoft.com/default...&Product=sql2k

You have have to use sp_dropserver and sp_addserver to get the name
of the server to be correct. Check SELECT @@servername, to see that it
has the right name.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2
i will give this a shot tomorrow.

i really appreciate your feedback!

"Erland Sommarskog" <so****@algonet.se> wrote in message
news:Xn*********************@127.0.0.1...
Go Browns! (go@browns.com) writes:
hello everyone. i am new to the group so i aplogize if this question has been answered recently...

our sql db machine is too old. we bought a new server with which to
replace it. the trick is, we want to keep the name of the machine and
db instance the same.

obviously, we don't plan on having two machine with the same name on the
network at the same time. how do we handle this?

my first thought is to name the new machine with a new name (mach2),
transfer over all the db's, take the old one (mach1) off of the network.
rename the machine/instance to the old one (mach1).

if i do this, can i drop the original instance on the new machine
(mach2)-->register the new (mach1)? will my data be there?
This KB article gives some good advice

http://support.microsoft.com/default...&Product=sql2k
You have have to use sp_dropserver and sp_addserver to get the name
of the server to be correct. Check SELECT @@servername, to see that it
has the right name.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Phil | last post by:
Hi all, I am pretty new to dB programming and a have a few questions which I will put in separate threads. I have only coded as a hobby and some limited work projects. I have recently been asked...
3
by: Willis | last post by:
I have a db on one machine, and another on a second machine. I have written some stored procedures that I want to copy to the second machine. As I understand it, there is a possibility to connect...
63
by: Nick Palmer | last post by:
Hi all, Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two DB2 databases and I need to get access to the tables in one from the other. In Oracle I would just create a DB...
2
by: Massimiliano Campagnoli | last post by:
Good morning, Database PRODUCTION was created on a system mamanged tablespace on drive c:\ Now drive c:\ is running out of space and I need to move PRODUCTION to the larger drive d:\ on the...
1
by: Nirbho | last post by:
Hi, I've got a c#.net web app that uses SQl Server 2000. It all works very well on my Development PC, but now I've got to install the app onto some real servers. I have 3 servers: 2 for the web...
4
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
1
by: maiami2 | last post by:
Hi Guys, I'm very new to access and I've been trying to get the hang of it over the last few days, but I've become very confused with various aspects of how to code it. Introduction: I am...
1
by: ll | last post by:
Hi, I have copied a MS SQL database to my local machine and am testing it with ASP pages, locally, on IIS. I have a db connect page that keeps the current connections for the live database. My...
15
by: mcjason | last post by:
I saw something interesting about a grid pair puzzle problem that it looks like a machine when you find each that work out the way it does and say with all the others that work out the way they...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.