disaster recovery
76 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?Solved171Views0likes2CommentsLesson Learned #345: How to get the most from Azure SQL Database - Session Delivered
This last April 27 we had a great opportunity and honor to deliver the session how to get the most of your Azure SQL database and Azure SQL Managed Instance with my colleague Sabrin Alsahsah Support Engineer in Azure SQL Database EMEA team.
2.6KViews1like2CommentsServer is not found in Active Directory @ Exchange Server 2000
Dear experts! Following the removal of an old server from the directory, my attempts to restart the server have been unsuccessful, and an error message appears while trying to recover the installation. I have tried performing a clean installation of the same versions and manually copying/entering the missing server, which I suspect was inadvertently deleted, but the error persists. I am uncertain where Exchange stores the absent server details that are causing the problem. I would like to know whether it is feasible to manually input the server information into the directory, and if so, where and how can I do this? CN=Configuration, CN=Services,CN=Microsoft Exchange, CN=<my org>, CN=Administrative Groups, CN=Exchange Administrative Group, CN=Servers <- under here... CN=<servername> and all protocols etc under... Configure, Microsoft Exchange Server 2010 Unattended Setup Preparing Exchange Setup Copying Setup Files COMPLETED The following server roles will be recovered Languages, Management Tools Server is not found in Active Directory. Server must be present in Active Directory to recover. The following server roles are already installed: BridgeheadRole, ClientAccessRole, MailboxRole, AdminToolsRole. Exchange Server setup encountered an error.672Views0likes0Comments