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