Rohit Garg

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

All authors

Interview Questions on SQL Server Database Mirroring

by Rohit Garg

MSSQLFUN

1) What is default port of Database Mirroring Endpoint?
Ans : 5022
2) Database Mirroring comes with which edition?
Ans: SQL Server 2005 SP1....

2014-11-17

20,512 reads

Script to Monitor SQL Server Database Mirroring Status

by Rohit Garg

MSSQLFUN

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...

2014-11-13

9 reads

Script to Monitor SQL Server Database Mirroring Status

by Rohit Garg

MSSQLFUN

SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database...

2014-11-13

1,504 reads

Add Witness to Existing SQL Server Database Mirroring

by Rohit Garg

MSSQLFUN

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...

2014-11-10

7 reads

Add Witness to Existing SQL Server Database Mirroring

by Rohit Garg

MSSQLFUN

1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2....

2014-11-10

4,000 reads

Remove Witness from SQL Server Database Mirroring

by Rohit Garg

MSSQLFUN

1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2)...

2014-11-07 (first published: 2014-10-27)

7,406 reads

SQL Server Database Mirroring Monitoring

by Rohit Garg

MSSQLFUN

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...

2014-11-03

6 reads