Setting up SQL mirroring
SQL mirroring is generally used for the disaster recovery model to provide high availability to the database. To implement SQL mirroring, you need at least two SQL server instances on the same server or the different server. One of the SQL server instances acts as the primary database instance, known as principal, while the other one is a mirror instance, know as mirror instance.
While configuring SQL mirroring for Citrix database, make sure the database is in full recovery mode and follow these steps:
Make sure the Citrix database that requires mirroring is in full recovery model.
Then, take a backup of the Citrix database with the transaction log and restore it on another SQL server instance, which will act as a mirror.
Tip
While restoring the database, the process should be executed using No recovery option.
To enable database mirroring, go to the primary SQL server instance using SQL server management studio; go to the properties of the Citrix database and then go...