how to track the Database correction

Question

Post reply

how to track the Database correction

jamessdba

SSCrazy

Points: 2256
More actions
May 19, 2011 at 3:53 am

#250495

Hi,
My manager asked me to track the Backend db correction
Ho to track the changes in the Db
example
suppose if i did not go to the office for 2 days
our developer team made changes & applied to Production Db on that days
How DBA will track the changes or audit .
Please reply
Thanks in advance

Viewing 6 posts - 1 through 5 (of 5 total)

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

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

Look the default trace in BOL you may get an idea.

Note : It not has each and every changes.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

homebrew01 SSC Guru Points: 55546 More actions · Answer 2

You could set up a server side trace to log the information you want.

Lowell SSC Guru Points: 323518 More actions · Answer 3

what if you are in the office those two days?

do you have anything in place to track it when you ARE there?

(Is you making changes to the database behind my back, Bobby Bouche?)

you still need to review the default trace, or set up a larger trace to track changesespecially if you need to tracl DML or login info, as previously suggested.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 4

jamessdba (5/19/2011)
Hi,
My manager asked me to track the Backend db correction
Ho to track the changes in the Db
example
suppose if i did not go to the office for 2 days
our developer team made changes & applied to Production Db on that days
How DBA will track the changes or audit .
Please reply
Thanks in advance

1) WHY are you allowing your developer team access to your production db?? THAT is your first and biggest mistake here. If they don't have access you won't NEED to track those changes.

2) You can use DDL triggers to audit object creation, drop, alters.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 5

Check EVENT DATA

http://msdn.microsoft.com/en-us/library/ms173781(v=SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms187909(v=SQL.90).aspx

Check DDL trigger

http://msdn.microsoft.com/en-us/library/ms190989(v=SQL.90).aspx

My Blog
www.aureus-salah.com