Microsoft – SQL Server – Database Mirroring – Metadata

Microsoft – SQL Server – Database Mirroring – Metadata


Transaction Safety

http://msdn.microsoft.com/en-us/library/ms191456(v=sql.105).aspx
Transaction safety is a mirroring-specific database property that determines whether a database mirroring session operates synchronously or asynchronously. There are two safety levels: FULL and OFF.

SAFETY FULL

Full transaction safety causes the session to operate synchronously in high-safety mode

SAFETY OFF

Turning off transaction safety causes the session to operate asynchronously, in high-performance mode.

     select 

                 @@servername as serverName
               , db_name(database_id) as databaseName
               , mirroring_safety_level as safetyLevel

     from  sys.database_mirroring tblDatabaseMirroring

     where  tblDatabaseMirroring.mirroring_guid is not null

     ;

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s