Tag: Database Mirroring

SQL Server – Database mirroring vs Log Shipping

SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

I would like to start this topic with very common question for database administrators. Question: What is difference between the Database Mirroring and Log Shipping? Which is preferable solution? Database Mirroring: Database mirroring is functionality in the SQL Server engine that reads from the transaction log and copies transactions from

» Read more
, ,

SQL Server – Database Mirroring for Disaster-Recovery Solution

SQL, SQL-Advanced, Varinder Sandhu

What is Database Mirroring? Database mirroring is a solution for increasing the availability of a SQL Server database. But it has been gained popularity as a disaster-recovery option. How Database Mirroring Working. The principle server sends the active transaction log record to the mirrored server. The mirrored server applies the

» Read more
, ,