September 27, 2009 at 3:17 am
Hi,
Just wanted to know the history of recovery models changed for a particular database or for all the databases. I did search in the sql server error logs. But did not any events logged for the database with regarding to change of recovery model. Anything needs to be enabled on the database level.
Thanks,
Himachalapathy
September 28, 2009 at 3:17 am
It should be in the SQL error log. I know I've seen it there before.
Date2009/09/28 11:29:55
LogSQL Server (Current - 2009/09/28 11:29:00)
Sourcespid52
Message
Setting database option RECOVERY to SIMPLE for database Testing.
Otherwise check the default trace. It might be there. There's no other place that it's stored, no history table. If you want that, you'll have to do it yourself, maybe with a database-level DDL trigger.
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
September 29, 2009 at 6:55 am
You can find information about the latest changes in recovery model in SQL LOGS.
September 29, 2009 at 7:17 am
As was mentioned above these changes were logged into SQL Server Log.
You can filter SQL Server Log files with text "Setting database option RECOVERY", and you will find history of recovery model changes.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply