Wednesday, March 28, 2012

recovery model change log

Hi
Is there any log of changes in recovery model?
If not directly, is there any way to know whether a
recovery model has changed in the past?
Thanks,
RonenMaybe profiler security audit event (Audit object derived event or Audit
object event) might show this...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ronen" <anonymous@.discussions.microsoft.com> wrote in message
news:013d01c3d4e9$a259f9e0$a001280a@.phx.gbl...
> Hi
> Is there any log of changes in recovery model?
> If not directly, is there any way to know whether a
> recovery model has changed in the past?
> Thanks,
> Ronen

No comments:

Post a Comment