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.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal

  • No labels