Saturday, November 26, 2011

Most Important Queries To Remember For Database Mirroring Administration

In this post I covered only most important scripts for mirroring administration. In my future posts I will cover some major issues of Mirroring and its resolutions/workarounds/fixes. 

How to manually fail over a database mirroring session?
1.       Connect to the principal server.
2.       Set the database context to the master database.
3.       ALTER DATABASE <database_name> SET PARTNER FAILOVER

How to Force Service in a Database Mirroring Session?
1.       Connect to the mirror server.
2.       Issue the following statement.
3.      
ALTER DATABASE <database_name> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS  

How to Resume a Database Mirroring Session?
1.       Connect to either partner.
2.       Issue the following T-SQL statement.
3.      
ALTER DATABASE <database_name> SET PARTNER RESUME 


How to pause a database mirroring session?
1.       Connect to either partner.
2.       Issue the following T-SQL statement.
3.      
ALTER DATABASE <database_name> SET PARTNER SUSPEND 


How to turn ON transaction safety?
1.       Connect to the principal server.
2.       Issue the following T-SQL statement.
3.      
ALTER DATABASE <database_name> SET PARTNER SAFETY FULL

How to turn OFF transaction safety?
1.       Connect to the principal server.
2.       Issue the following statement.
3.      
ALTER DATABASE <database_name> SET PARTNER SAFETY OFF
 
How to remove Database Mirroring?
1.       Connect to either partner.
2.       Issue the following T-SQL statement.
3.       ALTER DATABASE <database_name> SET PARTNER OFF


How to Remove the Witness from a Database Mirroring Session?
1.       Connect to either partner.
2.       Issue the following statement.
3.       ALTER DATABASE <database_name> SET WITNESS OFF



sql server, databases, Remove the Witness from a Database Mirroring, how to remove Database Mirroring in sql server, how to remove mirroring in sql server, mssqlfix.com, how to turn OFF transaction safety in mirroring, How to Force Service in a Database Mirroring Session, manual fail over in mirroring, automate fail over in mirroring, Setting Up Database Mirroring Using Certificates with examples. Use Certificates for a Database Mirroring Endpoint . Configure a Database Mirroring Session. Setting up database mirroring with certificates. Certificate Expiration on Database Mirroring and Recreating. How to replace expired certificates used in database mirroring. Implementing Database Mirroring in SQL Server 2008 R2. Implementing Database Mirroring in SQL Server 2012. Run SQL Server 2008 database mirroring with certificates. How to Allow Database Mirroring to Use Certificates for Inbound. How to Remove Database Mirroring. Sample script for configuring SQL Server database mirroring. Database Mirroring Setup Overview. step by step tutorial. step by step guide. Step by Step Installation. Step-by-step procedure. Database Mirroring step by step. Step by Step Guide to. sql server step by step. sql server step by step ebook. microsoft sql server step by step ebook. sql server step by step tutorial. step by step installation guide. microsoft sql server 2008 step by step

0 comments:

Post a Comment