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

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

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

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

Add Database File on Database invloved in DB Mirroring

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

Add Database File on Database invloved in DB Mirroring

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file...

Database Mirroring States (SQL Server)

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

Database Mirroring States (SQL Server)

SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :-
Mirroring stateDescriptionSYNCHRONIZINGThe contents of the mirror database are...

Configure SQL Server Database Mirroring

1) Take Full backup of database at Principle Server BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’ 2) Take Log Backup at Principle Server BACKUP LOG USERDB1 TO DISK =...