You are the database administrator for your company. You are administering the Sql1 SQL server that containsthe Prod1 database.
The Prod1 database is configured to use the Full Recovery model and implements a backup strategy to provideminimum downtime if a failure occurs.
You want to implement database mirroring to maximize the performance ofthis database. The mirror database Prod2 is maintained on the Sql2 server.
The following conditions must be met:
? The database should be made available to the users even if the mirrored server becomes unavailable.
? Service should be forced on the mirrored server if the principal server fails.
What should you do?