Can I use SQL Server Replication for moving MCMS databases around?
faq4.style.display=’none’; A: You can but chances are your sites will be broken due to the node cache being invalidated. The Microsoft Knowledge Base states that SQL Replication is not supported, and advises SQL backups are the best option. If you are looking for a solution to provide failover, SQL Log Shipping is supported, as detailed here.