Moving SQL DBs 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!!!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/defaul...1&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, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||i will give this a shot tomorrow.

i really appreciate your feedback!

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns94175A62E6CCYazorman@.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/defaul...1&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, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp