|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Problem with auditingWe are waiting for a SAN solution to be installed and our current sql server
has 8GB storage available and I am having our SQL auditing taking up tons of space. How can I disable all auditing or change settings on auditing within sql server manager? Also, all the old audit file; can they be moved off temporarily without comprimising their integrity? I have 167 GB of audit files but would like ideas on how to move them out of storage temp to a secondary server or workstation until the SAN is installed them move them back once storage isn't critical. Jeff Jeff (J***@discussions.microsoft.com) writes:
> We are waiting for a SAN solution to be installed and our current sql Which version of SQL Server?> server has 8GB storage available and I am having our SQL auditing taking > up tons of space. How can I disable all auditing or change settings on > auditing within sql server manager? Also, all the old audit file; can > they be moved off temporarily without comprimising their integrity? I > have 167 GB of audit files but would like ideas on how to move them out > of storage temp to a secondary server or workstation until the SAN is > installed them move them back once storage isn't critical. Which sort of auditing do you have active? -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx SQL SERVER 2005
Problem is I am not sure where to find out exactly what I am auditing. I have looked everywhere I can think of and can't find it. If I knew where the settings was located I would verify/add/change auditing where needed. Also, any idea if any negative ramifications would happen if I moved the audit log files off the server and archived it to another machine???? Jeff Show quote "Erland Sommarskog" wrote: > Jeff (J***@discussions.microsoft.com) writes: > > We are waiting for a SAN solution to be installed and our current sql > > server has 8GB storage available and I am having our SQL auditing taking > > up tons of space. How can I disable all auditing or change settings on > > auditing within sql server manager? Also, all the old audit file; can > > they be moved off temporarily without comprimising their integrity? I > > have 167 GB of audit files but would like ideas on how to move them out > > of storage temp to a secondary server or workstation until the SAN is > > installed them move them back once storage isn't critical. > > Which version of SQL Server? > > Which sort of auditing do you have active? > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > Keeping the logs available is a company policy issue. All of the 'older'
archives can be moved to where ever you wish to store them. They will need to be available when you have a purpose to examine the logs. To verify what is being logged, in SSMS, right click on your server, then [Properties], [Security]. -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous "Jeff" <J***@discussions.microsoft.com> wrote in message news:F6C25229-0AB0-4607-8599-1BF7054ED733@microsoft.com... > SQL SERVER 2005 > > Problem is I am not sure where to find out exactly what I am auditing. I > have looked everywhere I can think of and can't find it. If I knew where > the > settings was located I would verify/add/change auditing where needed. > Also, > any idea if any negative ramifications would happen if I moved the audit > log > files off the server and archived it to another machine???? > > Jeff > > "Erland Sommarskog" wrote: > >> Jeff (J***@discussions.microsoft.com) writes: >> > We are waiting for a SAN solution to be installed and our current sql >> > server has 8GB storage available and I am having our SQL auditing >> > taking >> > up tons of space. How can I disable all auditing or change settings on >> > auditing within sql server manager? Also, all the old audit file; can >> > they be moved off temporarily without comprimising their integrity? I >> > have 167 GB of audit files but would like ideas on how to move them out >> > of storage temp to a secondary server or workstation until the SAN is >> > installed them move them back once storage isn't critical. >> >> Which version of SQL Server? >> >> Which sort of auditing do you have active? >> >> >> -- >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >> >> Books Online for SQL Server 2005 at >> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx >> Books Online for SQL Server 2000 at >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >>  |
|||||||||||||||||||||||
Other interesting topics