Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw Performance Implications of Database Snapshots RE: Performance Implications of Database Snapshots

  • September 23, 2008 at 5:49 am

    #875571

    Andreas Berchtold (9/23/2008)

    We have a replication (many hundred of pocket pc's connected) and thus a snapshot.

    What I don't understand: Why more than 1 snapshot, isn't a snapshot "only" used to set up a replication and therefore you need only 1 snapshot?

    I'm not talking about snapshot replication, I'm talking about database snapshots. They're completely unrelated concepts.

    Database snapshots are a 'new' feature in SQL 2005 that allows for a point-in-time 'copy' of a database. They have nothing to do with snapshot replication or with snapshot isolation level.

    For more info on what database snapshots are, see -

    http://msdn.microsoft.com/en-us/library/ms175158(SQL.90).aspx

    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