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 the principal server instance to the mirror server instance.  Database mirroring can operate synchronously or asynchronously. Database mirroring supports only one mirror for each principal database. Database mirroring also supports

» 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 transaction log record one by one in sequence. Prerequisites The two partners, that is the principal server and mirror server, must be running the same edition of SQL Server. The

» Read more
, ,