Understanding Transaction Safety Levels
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 ...
Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
