How to make sql server backup files immutable

Question

How to make sql server backup files immutable without using Azure Storage?

Answer 1

immutable = not changeable?

Set "Readonly" property on file system level, as for any other file.

Answer 2

Hi @Dave Guo ,

Thank you for your reaching out and welcome to Microsoft Q&A!

From this official documentation, we can get the information:

If you want to know more information, please refer to Automatic generation and storage of database digests.

However, while SQL Server itself does not directly offer immutable backup options, several strategies can be employed to achieve immutability:

• Cloud Storage Options
• Hardware Solutions
• Backup Software with Immutable Features
• File System-Level Immutability

You could refer to this article to get more information, hope this can help you well!

Feel free to share your issues here if you have any concerns!

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications