I am currently reading into Database Mirroring...
A few questions regarding the transaction log came up my mind when trying to find a setup/disaster recovery strategy:
Imagine this situation: I am already running a SQL Server database... Now I want to add synchronized database mirroring by adding a mirror database to the setup.
Which prerequisites are required on the mirror database? Is it sufficient to use an empty database? Or do I need to restore a backup of the principal database first?
Same for disaster recovery:
Imagine the primary database goes offline and the Witness designates the mirror database as the principal database.
After re-installing Windows/SQL Server on the former principal machine, which prerequisites are required to let it become the mirror of the new principal database?
Do I need to create a current backup of the new principal database? Or will an old backup of the old principal database do? Or will even an empty database on the new machine do the job?
Finally, this is a more general question I have, regarding the transaction log:
The mirror database is fed from the principal database's transaction log...
How can I make sure that all necessary transaction log records are still available in the transaction log?
I couldn't find information on how records are deleted from the transaction log file... Does the transaction
View Complete Post