Exported event filter settings are saved in an XML format and can be applied to other registered SQL Server instances. This flexibility saves you time when you are configuring Event Filters on multiple SQL Server instances, and helps ensure consistent Event Filters across your environment. In addition, exporting allows you to back up your Event Filters to use should you need to reinstate an audited SQL Server instance. As you configure your Event Filters, consider what you would like to save for future use, and export the filters for that particular SQL Server instance or database.
To export your Event Filters:
- Navigate to Event Filters in the Administration tree.
- Click Export Filters on the Event Filters ribbon.
- Specify a file name or use the default name.
- Select the location to save the output file. Consider saving all Event Filters to a centralized location such as a network share.
- Click Save.