Anyone uses C2 auditing on SQL Server?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

cross SSCommitted Points: 1735 More actions · Answer 1

We use C2 because we are required by the government to do so.

From what I undertand, C2 audits all events.

The events are written to 2000MB rollover files located in mssql\data.

One disadvantage is that if SQL Server cannot write to the audit file used in C2, then SQL Server will automatically shut down!

If I weren't required by the government to enable C2, I'm not sure I would use it.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Hi Allen,

quote:
Why do you need C2 certified and what is the benefits and disadvantages.

these two links describe C2 a little bit more indepth than BOL does.

HTH

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

SSC Guru

Points: 51650

August 14, 2003 at 9:13 am

Thanks both.