Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is database mirroring?

April 26, 2017database mirroring

0

Posted

What is database mirroring?

1 Answer

0

Posted

Database Mirroring uses a new technology released with Microsoft SQL Server 2005. Two servers are used and are in constant communication. Database transactions are treated as a two phase operation – when a database transaction takes place, the transaction is 1st saved in the primary database on the primary server, and then saved in the backup database on the backup server before moving onto the next transaction request. In the event of the primary server failing, the backup database on the Backup server can be failed over and made live.