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
When a database is backed up, the TRUSTWORTHY database property is set to OFF. Therefore, on a new mirror database TRUSTWORTHY is always OFF. If the database needs to be trustworthy after a failover, extra setup steps are necessary after mirroring begins.
Nota
For information about this database property, see TRUSTWORTHY Database Property.
On the principal server instance, verify that the principal database has the Trustworthy property turned on.
SELECT name, database_id, is_trustworthy_on FROM sys.databases
For more information, see sys.databases (Transact-SQL).
After starting mirroring, verify that the database is currently the principal database, the session is using a synchronous operating mode, and the session is already synchronized.
SELECT database_id, mirroring_role, mirroring_safety_level_desc, mirroring_state_desc FROM sys.database_mirroring
For more information, see sys.database_mirroring (Transact-SQL).
Once the mirroring session is synchronized, manually fail over to the mirror database.
This can be done in either SQL Server Management Studio or using Transact-SQL:
Turn on the trustworthy database property using the following ALTER DATABASE command:
ALTER DATABASE <database_name> SET TRUSTWORTHY ON
For more information, see ALTER DATABASE (Transact-SQL).
Optionally, manually failover again to return to the original principal.
Optionally, switch to asynchronous, high-performance mode by setting SAFETY to OFF and ensuring that WITNESS is also set to OFF.
In Transact-SQL:
Change Transaction Safety in a Database Mirroring Session (Transact-SQL)
Remove the Witness from a Database Mirroring Session (SQL Server)
In SQL Server Management Studio:
TRUSTWORTHY Database Property
Set Up an Encrypted Mirror Database
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
Laluan pembelajaran
Implement a secure environment for a database service - Training
Implement a secure environment for a database service
Pensijilan
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Dokumentasi
TRUSTWORTHY database property - SQL Server
Learn about the TRUSTWORTHY database property, which indicates whether the instance of SQL Server trusts the database and its contents. The default is OFF.
cross db ownership chaining (server configuration option) - SQL Server
Learn how to use the cross db ownership chaining option in SQL Server. View considerations for turning cross-database ownership chaining on and off.
sp_changedbowner (Transact-SQL) - SQL Server
sp_changedbowner changes the owner of the current database.