Post reply

Recovery Model

  • November 6, 2009 at 9:50 am

    #213431

    Hi all, is there a way to tell when the recovery model of a database was changed and by whom?

    Thanks

  • November 6, 2009 at 9:53 am

    #1075994

    SQL 2005 has a default trace running that tracks that kind of change (and other DDL commands). You might find what you're looking for in there.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • November 6, 2009 at 10:07 am

    #1076008

    Look in the SQL error log.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 6, 2009 at 11:20 am

    #1076050

    GilaMonster (11/6/2009)

    Look in the SQL error log.

    Thanks Gail; for proof of concept i changed one of my databases, and here's a screenshot of the results: it's found in the Application log, but I could not find it in the default trace; i see some ALTERS to the database in it, but the TextData is null, so I don't know if that event is the Change of the RECOVERY or something else.

    I also have a DML trace running, and nothing shows up in that, either.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 7, 2009 at 2:39 am

    #1076279

    Hey Lowell,

    I have an uneasy feeling that I am misunderstanding you, but I believe the reference was to the SQL Server Logs (as shown in SSMS):

    Paul

    Paul White
    All articles available on SQL.kiwi
    @SQL_Kiwi

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply