October 2010
Intermediate to advanced
1008 pages
46h 16m
English
Transaction safety levels work hand in hand with operating modes. Based on the configured operating mode, the transaction safety level will either be set to FULL or OFF. In turn, if the database mirroring session is configured using Transact-SQL statements instead of SQL Server Management Studio, the transaction safety level determines the operating mode. Essentially, if the operating mode is running under synchronous transfer mode, the transaction safety level will be FULL, whereas if the transfer mode is running asynchronously, the transaction safety level will be OFF.
When using SQL Server Management Studio to configure a database mirroring session, the transaction safety level will automatically be ...
Read now
Unlock full access