-
Title
Is it possible to perform an archive of the Change Auditor database directly to a remote location -
Description
Is it possible to perform an archive of the Change Auditor database directly to a remote location
i.e: remote file share or NAS share
-
Cause
While Change Auditor will contact the SQL Server to create the Archive Database, it has no control on the location where SQL Server will store the files.
As such it is not possible to configure Change Auditor to select a location to store Archive data.
-
Resolution
Workaround
If needed to store the Archive Database in a different location, then create an Archive job and let it create the database before stopping it
Go to the SQL Server and check the location of the file
Detach the database and move the file to the desired location before attaching it again the the SQL Server
Run the Archive Job again and confirm that the data are being stored in the right location