September 12, 2007 at 1:21 pm
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 Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
September 13, 2007 at 10:14 am
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
Greg
September 13, 2007 at 10:47 am
That's the same conclusion I came to, just wanted to make sure I wasn't over looking something subtle. Thx anyway.
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply