Accessing Mirrored Data

• Chris Howarth-536003

  SSCommitted

  Points: 1775

  More actions

  May 13, 2009 at 12:27 am

  #204607

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

• Robert Davis

  One Orange Chip

  Points: 28027

  More actions

  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]