You can use the command line interface to archive audited events for registered SQL Server instances across your environment.

The archive operation supports the following syntax:

SQLcmCmd [-host CollectionServer] [-port number] archive {instance | all} [numberofdaysold] [-prefix phrase] [-partition {quarter | month | year}] [-timezone timezonename] [-nointegrity]

If you do not specify an optional parameter , the Collection Server uses the settings you selected in your archive preferences. An integrity check is performed unless you use the –nointegrity parameter in your command.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels