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 Website | Products | Buy | Support | Community | About Us | Resources | Legal