Best way to syncronize..?

[kenjoswe]

Hi all,

I have two servers one new and one old.
The old server is in production and must run as long as possible.
The new server is supposed to replace the old server.
What is the best way to syncronize these two server so that the new server can the same time as the old server is powered down? Subscribe? Restore from tape?

/Kent J.

 

[mrdenny]

There will be some downtime while you switch over.

I'd recommend the following.

Stop the old SQL Server.
Start the service in single user mode. (This will stop anyone but you from connecting).
backup all the databases
stop the old server
restore the databases to the new server
swing everything over to the new server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[peterking29]

I need to know how exaclty transfer database act 2000 to new 2005.I tried severals ways and had been impossible and I tried nbot to lose my info.Please help