Disaster Recovery
1 Topic
Disaster Recovery and with existing replication
Is there any Disaster Recovery plan for SQL Server that can also handle existing replication. In this case: I have an on-premise server with 9 TB in 18 user databases and existing replication with publications from 2 user databases to multiple on-premises subscribers. I have an Azure IaaS server with an identical SQL Server install and local disk allocations. My questions are: For a Basic Backup & Restore DR plan: Can existing replication be handled. The DR server has a new name? Can you restore the distribution database to another server. Can replication continue to the existing subscribers? Or is re-initializing all replication the only option? I never seen existing replication in documented in any DR plan. Does any DR documentation factor in existing replication. I know that when I restored user database in the past to another server that had existing replication, is was impossible to clean up that replication. And a full re-initial from scratch was the only option. For an Availability Group DR plan: Would Availability Groups, and making these two servers part of a WSFC handle existing replication any better? The distribution database is a system database, and I am not sure it can be handled any better with an AG. Would a complete re-initial of any existing replication be required after a failover?Solved41Views0likes2Comments