Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Change Transaction Safety in a Database Mirroring Session (Transact-SQL)
Collapse the table of content
Expand the table of content

Change Transaction Safety in a Database Mirroring Session (Transact-SQL)

Transaction safety is the attribute that controls the operating mode of the session. At any time, however, the database owner can change the transaction safety. By default, the level of transaction safety is set to FULL (synchronous operating mode).

Turning off transaction safety shifts the session into asynchronous operating mode, which maximizes performance. If the principal becomes unavailable, the mirror stops but is available as a warm standby (failover requires forcing service with possible data loss).

To turn on transaction safety

  1. Connect to the principal server.

  2. Issue the following Transact-SQL statement:

    
                  ALTER DATABASE <database> SET PARTNER SAFETY FULL
                
    

    where <database> is the name of the mirrored database.

To turn off transaction safety

  1. Connect to the principal server.

  2. Issue the following statement:

    
                  ALTER DATABASE <database> SET PARTNER SAFETY OFF
                
    

    where <database> is the mirrored database.

Community Additions

ADD
Show:
© 2015 Microsoft