Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NguyenL71
Posting Yak Master
228 Posts |
 Posted - 2014-03-06 : 17:01:24
|
| Hello,I need to find down who was changing the DB recovery model. Is there a TSQL command to track that?. I am looking error logs and can't find it. Of course, several of us in sysadmin role.SQL 2012.Thank you in advance. |
|
|
nickeyclayton
Starting Member
4 Posts |
Posted - 2014-03-07 : 02:37:11
|
| To use this TSQL command for tracking db changes.ALTER TABLE Person.ContactENABLE CHANGE_TRACKINGWITH (TRACK_COLUMNS_UPDATED = ON)and you could also try this tool to find out who are changing db recovery model. |
 |
|
|
NguyenL71
Posting Yak Master
228 Posts |
Posted - 2014-03-07 : 11:45:23
|
I am looking for TSQL tracking DB option changed for the last few days. NOT tracking on the table.quote:
Originally posted by nickeyclayton
To use this TSQL command for tracking db changes.ALTER TABLE Person.ContactENABLE CHANGE_TRACKINGWITH (TRACK_COLUMNS_UPDATED = ON)and you could also try this tool to find out who are changing db recovery model.
|
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-03-08 : 03:05:41
|
| For sql server 2012 recovery model change is normally logged in the SQL Server errorlogJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Tracking Who Change the DB Recovery Model.