Is the password used to encrypt the master key in the file. This password is subject to complexity checks. For more information, see Password Policy. The master key must be open and, therefore, decrypted before it's backed up. If it's encrypted with the service master key, the master key doesn't have to be explicitly opened. But if the master key is encrypted only with a password, it must be explicitly opened.īack up the master key as soon as it's created, and store the backup in a secure, off-site location. Authenticate to Azure Blob storageĪpplies to: SQL Server 2022 (16.x) and later. To back up the database master key to an Azure Blob storage, the following prerequisites apply:Ĭreate stored access policy and shared access storage.Ĭreate a SQL Server credential using a shared access signature.įor more information, see Tutorial: Use Azure Blob Storage with SQL Server. Requires CONTROL permission on the database. The following example creates a backup of the AdventureWorks2012 master key to a file. Because this master key isn't encrypted by the service master key, a password must be specified when it's opened.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |