C2 SQL auditing
Hi,
I setup my SQL 2000 Server to use C2 auditing. It is working.
My only problem is that my trace file does not get populated while I am
inserting/updating/select data or anything.
However, when I stop SQL server then my trace file gets populated.
I cannot stop a production SQL server on and off just to collect data and
the trace file is only limited to 200MB so I can wait till the end of day.
I am trying to do a audit report every 2hrs.
Am I doing something wrong? Or this is how C2 works?
I would appreciate all the help!
.
Relevant Pages
- C2 SQL auditing
... inserting/updating/select data or anything. ... when I stop SQL server then my trace file gets populated. ...
(microsoft.public.sqlserver.tools) - RE: Fulltext failure on a 2 node cluster
... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
(microsoft.public.sqlserver.clustering) - Re: HELP PLEASE ~ ???
... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
(microsoft.public.dotnet.framework.aspnet) - Re: Multi-Channel Raid VS SAN Storage
... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
(microsoft.public.sqlserver.setup) - Re: Multi-Channel Raid VS SAN Storage
... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
(microsoft.public.sqlserver.setup) |
|
