Archives: November 2014
1. Do not change collation of TempDB from the SQL Server instance collation.
2. Do not change the TempDB database owner from sa.
3. Do not drop the TempDB database.
4. Do not drop or revoke the guest user from the database.
5. Do not change the recovery model from… Read more
The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.
Those who are facing severe issues with their environment, they can… Read more
The 3rdcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.
Those who are facing severe issues with their environment, they can plan… Read more
1) What is default port of Database Mirroring Endpoint?
Ans : 5022
2) Database Mirroring comes with which edition?
Ans: SQL Server 2005 SP1. Or SQL Server 2005 RTM with trace flag 1400
3) When I configure mirroring I’m receiving the below errror,
One or more of the server network… Read more
SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database Mirroring send logs to mirror from principle. We need to monitor Database Mirroring status continuously to ensure that everything is working fine. We can use MSDB.SYS.SP_DBMMONITORRESULTS system store procedure to… Read more
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2. Click Configure Security, Configure Database Mirroring Security Wizard welcome screen appears, click Next.
3. In the Include Witness Server dialog box, click Yes, and then click Next.
4.… Read more
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 >… Read more