Update new storage account key in Auditing Logs for SQL Server Service in Azure

Question

I have a SQL server service with Auditing Logs enabled and I'm using a storage account to store the logs using its access key. I will renew the storage account keys; how can I update the new key in my Auditing log configuration in order to not lose my daily logs? or If I renew the key, it will automatically update in my Auditing Logs settings.

Answer 1

@Jonathan Vasquez Chicata (AEGIS COMPANY)

When you rotate the key in Azure there is no need to update SQL Auditing to use the new key. This is automatically done for you. Please note that before you rotate the key you can switch between Primary and Secondary access key to maintain completeness of the logs. This is noted in the portal.

Hope this helps! Let me know if you have other questions.

---

If you still have questions, please let us know in the "comments" and we would be happy to help you. Comment is the fastest way of notifying the experts.

If the answer has been helpful, we appreciate hearing from you and would love to help others who may have the same question. Accepting answers helps increase visibility of this question for other members of the Microsoft Q&A community.

Thank you for helping to improve Microsoft Q&A!