Peristiwa
31 Mac, 11 PTG - 2 Apr, 11 PTG
Acara pembelajaran SQL, Fabric dan Power BI terbesar. 31 Mac - 2 April. Gunakan kod FABINSIDER untuk menjimatkan $400.
Daftar hari iniPelayar ini tidak lagi disokong.
Naik taraf kepada Microsoft Edge untuk memanfaatkan ciri, kemas kini keselamatan dan sokongan teknikal yang terkini.
Applies to:
SQL Server
Transaction safety is the attribute that controls the operating mode of the session. At any time, however, the database owner can change the transaction safety. By default, the level of transaction safety is set to FULL (synchronous operating mode).
Turning off transaction safety shifts the session into asynchronous operating mode, which maximizes performance. If the principal becomes unavailable, the mirror stops but is available as a warm standby (failover requires forcing service with possible data loss).
Connect to the principal server.
Issue the following Transact-SQL statement:
ALTER DATABASE <database> SET PARTNER SAFETY FULL
where <database> is the name of the mirrored database.
Connect to the principal server.
Issue the following statement:
ALTER DATABASE <database> SET PARTNER SAFETY OFF
where <database> is the mirrored database.
ALTER DATABASE Database Mirroring (Transact-SQL)
Database Mirroring Operating Modes
Peristiwa
31 Mac, 11 PTG - 2 Apr, 11 PTG
Acara pembelajaran SQL, Fabric dan Power BI terbesar. 31 Mac - 2 April. Gunakan kod FABINSIDER untuk menjimatkan $400.
Daftar hari iniLatihan
Dokumentasi
ALTER DATABASE Database Mirroring (Transact-SQL) - SQL Server
ALTER DATABASE Database Mirroring (Transact-SQL)
Switch database mirror roles - SQL Server Database Mirroring
Learn about switching database mirroring roles, where a mirror server becomes the principal in response to failures or for admin purposes in SQL Server.
Remove Database Mirroring (SQL Server) - SQL Server Database Mirroring
Learn how to remove database mirroring from a database by using SQL Server Management Studio or Transact-SQL in SQL Server.