Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

See When the recovery model was switced on a database. Expand / Collapse
Author
Message
Posted Friday, January 24, 2014 7:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 31, 2014 7:21 AM
Points: 1, Visits: 8
Hi,

Is there a way to See When the recovery model was switched on a database?

Regards Urban
Post #1534482
Posted Friday, January 24, 2014 8:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 21, 2014 4:39 AM
Points: 843, Visits: 2,488
Hi,

There should be a message in the SQL Server error log, e.g. SETTING DATABASE OPTION RECOVERY TO SIMPLE FOR DATABASE XXXXX

Also, i just changed the recovery model on one of my databases, and got an EventClass 164, ObjectType 16964 logged in the default trace, which might be worth looking up
Post #1534517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse