Move SQL-Server Database with zero downtime
Posted
by Uwe
on Server Fault
See other posts from Server Fault
or by Uwe
Published on 2010-03-24T12:59:51Z
Indexed on
2010/03/24
13:03 UTC
Read the original article
Hit count: 442
Hello,
how is it possible to move a sql 2005 db to a different sql 2008(!) server without any downtime? The system is 24/7 and has to be moved to a differen server with a different storage.
We tried copy database, but that does not keep the whole db synchronus at the end of the process but only tablewise.
© Server Fault or respective owner