Category Archives: SQL Server

Add Database File on Database invloved in DB Mirroring.

The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 4 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe issues with their environment, they can plan to test CU4 in test environment & … Continue reading →

1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2) To remove the witness, delete its server network address from the Witness field. 3) Click Ok to confirm. You can also perform the same action by below T-SQL. ALTER DATABASE database_name SET WITNESS … Continue reading →

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically. Steps to Add Database File on Database involved in DB Mirroring :- 1) Break the Mirroring ALTER DATABASE USERDB1 SET PARTNER … Continue reading →

SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :- Mirroring state Description SYNCHRONIZING The contents of the mirror database are lagging behind the contents of the principal database. The principal server is sending log records to the mirror server, which is applying the changes to the mirror database to roll it … Continue reading →