Solved

how to change audit log files of " C2 audit" in SQL 2005

Posted on 2009-05-03
3
1,259 Views
Last Modified: 2012-08-13
Good Day

by default it is going to this database folder:
G:\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Thanks
0
Comment
Question by:MOSS_Lover
3 Comments
 
LVL 31

Accepted Solution

by:
RiteshShah earned 250 total points
ID: 24293021
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 25518113
relevant part:

Theres no way to change C2 audit mode files location from the instance data directory. 
You can change the default location of the data directory by using the Server Properties dialog Database Settings page.

Open in new window

0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stored procedure 4 37
Set the max value for a column 7 41
Isolation level in SQL server 3 54
How to order Highest and lowest value rows alternatively in SQL Server ? 4 63
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question