Home » 2014 (Page 3)
Yearly Archives: 2014
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working fine. We are monitor Database Mirroring by 2 ways :- 1) SSMS : Connect to Principle Server > Select Database > Right Click , Go to … Continue reading
Add Database File on Database invloved in DB Mirroring
Add Database File on Database invloved in DB Mirroring.
Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !
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
Remove Witness from SQL Server Database Mirroring
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