Post reply

Recovery Model logging

  • November 24, 2009 at 9:10 pm

    #140206

    Hi,

    IS there any way to trace out if any login having sysadmin rights changing the recovery model is logged anywhere ???

    Because this effect the daily backup schedules of full and transaction logs and will be a problem if the system is crashed and endup with data loss.

    Thanks!

  • November 25, 2009 at 12:15 am

    #1083825

    SQL Server 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 25, 2009 at 12:41 am

    #1083842

    Thank You Gila!:-)

  • November 25, 2009 at 5:35 am

    #1083918

    i dont know how your backup goes but if you use backup jobs your transaction log backup will fail if you do a transaction log backup on a database with recoverymode =simple. if you use sql backup you have the option to mail you if the backup failed (for example).

    so if you have something monitoring your transaction log backup jobs and the jobs are doing an hourly backup you get a notification in an hour something is wrong ...

  • November 26, 2009 at 9:19 pm

    #1084763

    Yeah! True i agree to the point you have mentioned.

    Thank you.

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

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