Moving a SQL Server 2000 Database from one server to another advice

Hi, i was after some advice on moving a SQL Server 2000 database from one server to another.

Usually i would do this by backing up the database on the original server the copying it accross the LAN to the new server and restoring it there. This database is 10Gb in size and copying it accross the LAN will take some time and i would like to minimise downtime if possible. The database is at a customer site where i am not responsible for the network or Hardware.

Thanks in advance for your help

Nick

Hi,

if you are doing it just one time, do a plain backup and restore. If you are not sure if the connection breaks meanwhile copying use something like robocopy which can resume copying if copying breaks.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi thanks for the reply

I was wondering if i moved the database earlier in the week, and kept the users logged into the original then when it was time to move the users accross i could backup the transaction log and apply that to the database moved earlier on in the week. Would that then apply all the changes since the database had been moved ?

Nick

|||

Hi,

if you have differential backups or Transactional backups meanwhile you can just restore them together with the full backup. That should work for restoring the database.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de