Disaster Recovery
77 TopicsDisaster 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?Solved41Views0likes2CommentsAzure Event Hubs Geo-disaster recovery is now generally available
First published on on Dec 18, 2017 Geo-disaster recovery for Azure Event Hubs is now generally available! The following article gives an overview of how to enable regional disaster recovery capability for Azure Event Hubs.5KViews0likes1CommentHow to Perform an Authoritative System State Restore in SBS 2008/2011 Standard
First published on TechNet on Mar 31, 2011 [Today's post comes to us courtesy of Shawn Sullivan from Commercial Technical Support]If you have ever been in the situation where you had to recover an Active Directory object that was accidentally deleted within a multiple Domain Controller environment, then you are probably somewhat familiar with the term “authoritative restore” and what it does.