Post reply

Snapshots going into recovery mode

  • February 4, 2011 at 4:48 pm

    #148336

    Hello Everyone:

    I am running into repeated occurrences of a snapshot that goes into recovery mode as soon as it gets created. Can someone shed some light on why this would be the case? Once the snapshot goes into recovery mode, it starts to consume a lot of I/O partly due to a number of other processes running and takes a while to complete the recovery process.

    Any insight into the above is greatly appreciated. Many thanks in advance for you time.

    Regards,

    krish.

  • February 5, 2011 at 1:56 am

    #1282785

    Database snapshot?

    Are there long-running transactions at the time you create them?

    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

  • February 7, 2011 at 7:16 am

    #1283099

    There are multiple types of snapshots in SQL Server. Please clarify which type you're referring to.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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