Category Archives: High Availibility

10 SQL Server Disaster Recovery Solutions

What is SQL Server Disaster? Disaster is an event that makes continuation of normal functions impossible. In business terms, any incident which result affects business or stops business transactions is a disaster for example Orders can not be placed, think about Amazon where every business transaction is online and customer is unable to place an [...]

HADR Demo Questions

Question: Is the High Performance replica mode available in Denali Standard or is that an Enterprise feature? Answer: Enterprise Edition and higher editions only Question: Why say all on connections if secondary only allows read and the setting is only for secondary? Answer: The option allows any legacy applications to connect without changing the connection [...]

How to Monitor Database Mirroring, SQL Server?

SQL Server Mirroring can be monitored SQL Server Management Studio or via TSQL Queries Monitor LOG Shipping status Using SSMS Database Mirroring Monitor is a graphical user interface tool that enables system administrators to view and update status and to configure warning thresholds on several key performance metrics. How to Access Database Mirroring Monitor ? [...]

How to perform SQL Server Mirroring Manual Failover?

What is SQL Server Mirroring Failover ? When the principal server is offline, the mirror and the witness will form a quorum and promote the mirror to be the principal. This is known as Mirroring Failover. Failover can be either automatic or manual. Automatic Failover: If the principal server fails in High Availability mode, failover [...]

SQL Server Mirroring Automatic Failover

What is Automatic Failover in SQL Server Mirroring? When the principal server is offline, the mirror and the witness will form a quorum and promote the mirror to be the principal. Once this is done users can continue work as usual on the other server (New Principal Server) An automatic failover causes the mirror server [...]

How to Setup Mirroring in SQL Server ?(Screen Shots)

What is Mirroring in SQL Server ? Database mirroring is an alternative high-availability solution to failover clustering in SQL Server. Database mirroring supports automatic failover, but does not require cluster-capable hardware, and can therefore provide a cost-effective alternative to failover clustering. In this Article, we will implement Mirroring with witness Server and will Automatic Failover [...]

Database mirroring must be removed before you drop SQL Server database

Error Message TITLE: Microsoft SQL Server Management Studio —————————— Drop failed for Database ‘Test_SQLServer_Mirroring’.  (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Database&LinkId=20476 —————————— ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— The database ‘Test_SQLServer_Mirroring’ is enabled for database mirroring. Database mirroring must be removed before you drop the database. (Microsoft SQL Server, [...]