Accessing Mirrored Data

  • Chris Howarth-536003

    SSCommitted

    Points: 1775

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

  • Robert Davis

    One Orange Chip

    Points: 28027

    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 2 (of 2 total)

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