Post reply

Accessing Mirrored Data

  • May 13, 2009 at 12:27 am

    #204607

    Comments posted to this topic are about the item Accessing Mirrored Data

  • May 13, 2009 at 9:56 am

    #993851

    The statement that "snapshots generally take seconds to drop and create" is accurate. The key is generally. There are cases where creating a snapshot can take a very long time. You need to make sure that if you schedule automatic snapshot creation, it isn't done while there are long running processes, such as a large index rebuild, in mid-execution. Any open transactions in the database get "rolled back" in the snapshot as part of the creation.

    You can read more about that here: Database snapshots can take a long time to create

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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