Dismiss Notice

Register now to be one of the first members of this SharePoint Community! Click here it just takes seconds!

Dismiss Notice
Welcome Guest from Country Flag

Azure SQL Database Auditing – Move from Azure Table Storage to Blob Storage

Discussion in 'Official Microsoft News' started by Roberto Cavalcanti -, Apr 13, 2017.

Thread Status:
Not open for further replies.
  1. Roberto Cavalcanti -

    Roberto Cavalcanti - Guest

    Blog Posts:
    Microsoft recently deprecated the use of Azure Table storage for SQL Database Auditing. Use Azure Blob Storage to save your auditing files instead.

    If you were using Azure Table Storage for your auditing data, here is a simple step by step on how to move to Azure Blob Storage instead.

    On this database, called “Sales”, I am inheriting the auditing settings from the server “auditingdemo”. Auditing is not individually configured for this database, as this is not a supported feature for Auditing with Table Storage (for more details about it, please read the session “Blob/table differences in server auditing policy inheritance”).

    Image 1 – Auditing with Azure Table Storage

    To change it from Table to Blob Storage, all you need to do is the following:

    1. Go to the SQL Database server, and modify it from Table to Blob. (Yes, as simple as that)
    2. Click Save, and now you have Auditing type Blob at the server level:

    Image 2 – Auditing with Azure Blob Storage

    That’s it. Now you have blob auditing If you need to have database level auditing, you may set it at the database level as well, but it is not a recommended setting, as per the feature documentation:

    You should avoid enabling both server Blob auditing and database Blob auditing together, unless:

    • You need to use a different storage account or retention period for a specific database.
    • You want to audit different event types or categories for a specific database than are being audited for the rest of the databases on this server (e.g. if table inserts need to be audited only for a specific database).

    You may ask: “What about the auditing data that was in the Table Storage? Will I lose it?

    The answer is No. The old data continues in Table Storage, and the new auditing data goes to blob storage from this point onwards.

    Continue reading...
Thread Status:
Not open for further replies.

Share This Page

LiveZilla Live Chat Software