This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 34%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
How to make sql server backup files immutable without using Azure Storage?
Hi @Dave Guo ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress.
By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Lucy Chen
Hi @Dave Guo ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress.
By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Lucy Chen
Hi @Dave Guo ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress.
By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Lucy Chen
immutable = not changeable?
Set "Readonly" property on file system level, as for any other file.
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:
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
Hi @Dave Guo ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress.
By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Lucy Chen
Hi @Dave Guo ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress.
By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Lucy Chen