Copy Databases to another machine with same Windows name

Question

Copy Databases to another machine with same Windows name

psconsulting

SSC Eights!

Points: 944
More actions
March 17, 2004 at 7:40 am

#82469

I have been given the task of copying all the databases from one server to another server and my boss wants to keep the same windows name. I know I can't have them both up on the network at the same time. Any best practice docs out there that might be helpful? Thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

diogenes0412 SSC Enthusiast Points: 117 More actions · Answer 1

I had to do that myself a couple of months ago. Here are some articles I found. They describe a similar plan, but the second one has a little more detail. The first one is by Andy Warren.

http://www.databasejournal.com/features/mssql/article.php/1479841

http://vyaskn.tripod.com/moving_sql_server.htm

I referred to both of them, and the move went well.

Johan Bijnens SSC Guru Points: 135376 More actions · Answer 2

First take a look at the articles diogenes0412 mentioned !

then try this.

Clone sqlserver-server (i.e. keep servername,...)

- install windows and copy windows-authorities if in use.

- Install sqlserver on your new server at exact locations (paths) as your old server and up to the software level (servicepack/hotfix) as your old server.

- stop sqlserver service. (and avoid automatic startup after reboot)

- copy all your sql-server related directories from your old server to your new server

(you might even change your new servers servername to hook up and perform this operation. Don't forget to deplug and rename afterward )

Remember to keep exact locations !!!

- start sqlserver

- "Huston : we have liftoff"

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

ButchH Ten Centuries Points: 1073 More actions · Answer 3

Perhaps it would be BETTER to rename the OLD server before copying the files to the new server. Sounds to me like the old server will be out of commission after the deed is done, so why make extra work of having to rename the NEW server TWICE?

Butch