January 6, 2010 at 7:56 am
Want to know below things as part of DBA tasks...Thanks!
How to protect the database transaction logs from alteration and deletion.
How to perform log audit validation of database changes when unauthorized changes occur.
January 6, 2010 at 8:11 am
kareem007 (1/6/2010)
How to protect the database transaction logs from alteration and deletion.
The transaction logs cannot be altered, trying to do so will render the database suspect. Deleting them will often do much the same thing. Plus, they're locked exclusively by SQL while the service is running.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2010 at 8:18 am
Thanks for your reply GilaMonster!
Presently I am saving database changes script/code, input/outpur and also approved email in a network share for future audit.
In SQL is there any way to perform database log audit?
January 6, 2010 at 8:31 am
laddu4700 (1/6/2010)
In SQL is there any way to perform database log audit?
Plenty of ways. Depends what you want to log, how you want the info stored, etc.
I suggest you hit your favourite search engine and look for SQL Server audit related pages. You'll find tonnes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply