SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Tracking Who Change the DB Recovery Model.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

NguyenL71
Posting Yak Master

USA
208 Posts

Posted - 03/06/2014 :  17:01:24  Show Profile  Reply with Quote
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 - 03/07/2014 :  02:37:11  Show Profile  Reply with Quote
To use this TSQL command for tracking db changes.

ALTER TABLE Person.Contact
ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = ON)

and you could also try this tool to find out who are changing db recovery model.

Edited by - nickeyclayton on 03/07/2014 02:40:26
Go to Top of Page

NguyenL71
Posting Yak Master

USA
208 Posts

Posted - 03/07/2014 :  11:45:23  Show Profile  Reply with Quote

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.Contact
ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = ON)

and you could also try this tool to find out who are changing db recovery model.

Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2004 Posts

Posted - 03/08/2014 :  03:05:41  Show Profile  Visit jackv's Homepage  Reply with Quote
For sql server 2012 recovery model change is normally logged in the SQL Server errorlog

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000