Share via

Azure SQL MI Database Manual Backup & Retention Policy

Fadi Alzebdeh 25 Reputation points
2024-05-19T08:21:44.4666667+00:00

why do we get such an error when we try to do manual backup for sql server managed instance?

In this backup we redirect the backup to url (storage account), but it fails due to encryption error.

User's image

when we also use command line it fails with the same error:

TO URL = N'https://storageAccounturl/mspsdp18May2024.bak'

WITH COPY_ONLY

, STATS = 1

, INIT

, MAXTRANSFERSIZE = 4194304

, BLOCKSIZE = 512;

Msg 41922, Level 16, State 1, Line 14

The backup operation for a database with service-managed transparent data encryption is not supported on SQL Database Managed Instance.

Msg 3013, Level 16, State 1, Line 14

BACKUP DATABASE is terminating abnormally.

The second question, if the retention policy shows last backup 11/5/2024 how can we change policy to daily? does just in time concept work here?

can someone help here?

Azure SQL Database

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,161 Reputation points MVP
    2024-05-19T13:46:03.3866667+00:00

    Take in consideration also that you cannot backup a database encrypted with service-managed Transparent Data Encryption (TDE). Try to disable temporarily Transparent Data Encryption on the database you want to backup for the backup operation to finish successfully. Please follow the steps outlined in this technical article.

    On this second technical article, you will receive information about how to configure backup retention for Azure SQL Managed Instance.

  2. Fadi Alzebdeh 25 Reputation points
    2024-05-20T04:50:21.6566667+00:00

    one more question, if it shows last backup 12/5/2024 how does the PITR work? i could not understand this point, will continue backing up after the 12/5/2024 till the next full backup or how does the mechanism work here?