You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

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 monitor, audit and alert on SQL user activity and data changes.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal

  • No labels