Resolve SQL Corruption Caused Due to Transaction Log Files Removal Interrupting Database Mirroring


Database Mirroring: In SQL Server 2008, you can use the feature of database mirroring between two databases. It can help in the data loss situations where a database damages for some reason; you can back up your database from the mirror database.

Transaction Log Files Removed Accidentally: If by chance, you remove the transaction log files; the database mirroring session can interrupt. This causes the Principal Server to fail and you will not be able to restore the data from mirror server. This can cause corruption damaging the database.

A Possible Scenario: Consider a practical scenario where you are using SQL Server 2008 SP1 (Service Pack 1) or MS SQL Server 2008. You configure mirroring between 2 databases.

Transaction Log Files Removed