Tim Mitchell
SSCoach
Points: 15695
More actions
September 12, 2007 at 1:21 pm
#69965
Greetings all,
Is there a way to find out when and by whom the recovery model for a specific database was changed in SQL 2000?
thx
Tim
Tim MitchellTimMitchell.net | @tmitch.net | Tyleris.comETL Best Practices
Greg Charles
SSC-Forever
Points: 45403
September 13, 2007 at 10:14 am
#733534
I think not, unless a trace was running at the time. I tried switching the recovery model of a test database then looked in the SQL error log and the server logs. Nothing was logged for the operation.
Greg
September 13, 2007 at 10:47 am
#733552
That's the same conclusion I came to, just wanted to make sure I wasn't over looking something subtle. Thx anyway.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply