Skip to main content
We’ve updated our Terms of Service. A new AI Addendum clarifies how Stack Overflow utilizes AI interactions.
edit for clarity and added info on how to change default db location.
Source Link
Sim
  • 1.9k
  • 2
  • 17
  • 17

Have a read of Enabling and Disabling C2 Auditing.

BeforeHowever before you do turn this off, hadn't you better check onas to why they are on in the first place? Do you have a business requirement for C2 Audit Traces to be turned on?

If you do have a requirement to keep them it looks like your best bet is to, you could write a script to move them every so often to a suitable secure location. TheyBy default they are written to the default data directory by defaultselected on install. You would haveIf this is a problem you may be able to change the location of the default data directory but will probably require bouncing the services for it to move where they are createdtake affect.

To change the default database file location, open SQL Server Management Studio and right click the Server object, select Properties and then Database Settings.

Have a read of Enabling and Disabling C2 Auditing

Before you do turn this off hadn't you better check on why they are on in the first place? Do you have a business requirement for C2 Audit Traces to be turned on?

If you do have a requirement to keep them it looks like your best bet is to write a script to move them every so often to a suitable secure location. They are written to the default data directory by default. You would have to change the location of the default data directory to move where they are created.

Have a read of Enabling and Disabling C2 Auditing.

However before you do turn this off, hadn't you better check as to why they are on in the first place? Do you have a business requirement for C2 Audit Traces to be turned on?

If you do have a requirement to keep them, you could write a script to move them every so often to a suitable secure location. By default they are written to the default data directory selected on install. If this is a problem you may be able to change the location of the default data directory but will probably require bouncing the services for it to take affect.

To change the default database file location, open SQL Server Management Studio and right click the Server object, select Properties and then Database Settings.

added info on maintaing and moving them.
Source Link
Sim
  • 1.9k
  • 2
  • 17
  • 17

Have a read of Enabling and Disabling C2 Auditing

Before you do turn this off hadn't you better check on why they are on in the first place? Do you have a business requirement for C2 Audit Traces to be turned on?

If you do have a requirement to keep them it looks like your best bet is to write a script to move them every so often to a suitable secure location. They are written to the default data directory by default. You would have to change the location of the default data directory to move where they are created.

Have a read of Enabling and Disabling C2 Auditing

Before you do turn this off hadn't you better check on why they are on in the first place? Do you have a business requirement for C2 Audit Traces to be turned on?

Have a read of Enabling and Disabling C2 Auditing

Before you do turn this off hadn't you better check on why they are on in the first place? Do you have a business requirement for C2 Audit Traces to be turned on?

If you do have a requirement to keep them it looks like your best bet is to write a script to move them every so often to a suitable secure location. They are written to the default data directory by default. You would have to change the location of the default data directory to move where they are created.

Source Link
Sim
  • 1.9k
  • 2
  • 17
  • 17

Have a read of Enabling and Disabling C2 Auditing

Before you do turn this off hadn't you better check on why they are on in the first place? Do you have a business requirement for C2 Audit Traces to be turned on?