How to Change Transaction Safety in a SQL Server Database Mirroring Session

To turn on transaction safety, run this Transact-SQL statement from the principal server:

ALTER DATABASE [Database_Name] SET PARTNER SAFETY FULL

To turn off transaction safety, run this Transact-SQL statement from the principal server:

ALTER DATABASE [Database_Name] SET PARTNER SAFETY OFF