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


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”).

auditing-table

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:

auditing-blob

Image 2 - Auditing with Azure Blob Storage

That’s it. Now you have blob auditing enabled. 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.

Comments (3)

  1. Chris Gray says:

    Is there a date set yet for when table auditing option will be removed from Azure?

    1. Subbu K says:

      Table Auditing option will be removed end of Sept 2017. And threat detection will stop supporting table auditing by end of this month (May-2017).

  2. Rody says:

    With Table storage now deprecated, how can we use the PowerBI "SQL Database Auditing" service? This service is only communicating with table storage and we had created several Dashboards for auditing purposes.

Skip to main content