You have an on-premises server that has Microsoft SQL Server 2022 installed. The server contains multiple databases. You have an Azure subscription that contains multiple Azure SQL databases. You…

Question

Options

• Aan Azure Files share
• BAzure Table storage
• Ca Recovery Services Vault
• DAzure Blob Storage

• A
  5% (2)
• B
  3% (1)
• C
  5% (2)
• D
  86% (32)

Explanation

SQL Server backup and restore with Azure Blob Storage To store Microsoft SQL Server 2022 database backups centrally, you can utilize features like Azure Blob Storage, S3-compatible object storage, or shared network drives. Consider using SQL Server Management Studio (SSMS) or Maintenance Plans to automate backups to these central Azure Blob Storage: SQL Server 2022 integrates with Azure Blob Storage for backups, allowing you to store them in You can use the BACKUP TO URL syntax with the s3:// or https:// protocol to specify the Azure Blob Storage location. You'll need to create an Azure storage account and a container, and then create a SQL Server credential to authenticate with the storage. https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-and- restore-with-microsoft-azure-blob-storage-service

No community discussion yet for this question.