Post reply

Backup and recovery model

  • July 31, 2012 at 3:39 am

    #259940

    i have asked this question please let me know what to answer on this, Q is :

    one database is there which is in full recovery model every hour transaction log backup happens, what will happen if recovery model changes from full to simple and then again simple to full?

  • July 31, 2012 at 3:53 am

    #1519595

    Log backups will fail until a full or differential backup is taken.

    Please read through this - Managing Transaction Logs[/url]

    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

  • July 31, 2012 at 4:02 am

    #1519596

    ok, can you please tell me why the backup will get failed, what will happen internally because recovery model changed from full to simple and from simple to full at the same time.

  • July 31, 2012 at 4:11 am

    #1519597

    Did you read the article?

    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

  • July 31, 2012 at 4:35 am

    #1519605

    ohh sorry i dint see that link.

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

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