November 16, 2009 at 12:45 pm
I recently noticed that the Recovery Model on a database had been changed from FULL to SIMPLE by an administrator.
Does SQL capture any "queryable" data / metadata to indicate when that change was made?
Thanks
November 16, 2009 at 12:48 pm
SQL Server Error Logs must have the information. Check it.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 16, 2009 at 2:42 pm
Thank you for the response Bru. Apparently I do not have the correct permissions to read the error log. However, I did find helpful information from the backup log.
November 17, 2009 at 7:24 am
You can also find the information from your server Application or System event log files.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply