Set Up a Mirror Database to Use the Trustworthy Property

To setup a mirror database to use the Trustworthy Property

1. On the principal server instance, verify that the principal database has the Trustworthy property turned on.
   
   

   SELECT name, database_id, is_trustworthy_on FROM sys.databases 

2. After starting mirroring, verify that the database is currently the principal database, the session is using a synchronous operating mode, and the session is already synchronized.
   
   
   
   

   SELECT database_id, mirroring_role, mirroring_safety_level_desc, mirroring_state_desc FROM sys.database_mirroring

3. Once the mirroring session is synchronized, manually fail over to the mirror database.
   This can be done in either SQL Server Management Studio or using Transact-SQL:
   
   • How to: Manually Fail Over a Database Mirroring Session (SQL Server Management Studio)
   • How to: Manually Fail Over a Database Mirroring Session (Transact-SQL)
     
     
4. Turn on the trustworthy database property using the following ALTER DATABASE command:
   
   
   
   

   ALTER DATABASE <database_name> SET TRUSTWORTHY ON

5. Optionally, manually failover again to return to the original principal.
   
   
6. Optionally, switch to asynchronous, high-performance mode by setting SAFETY to OFF and ensuring that WITNESS is also set to OFF.
   
   Ref: MSDN