Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Creating a Database Snapshot RE: Creating a Database Snapshot

  • March 9, 2009 at 10:35 am

    #956197

    Jose Ianuck (3/9/2009)

    The big problem is to avoid locks or bad performance

    Locks it will avoid, bad performance, maybe , maybe not

    But create a snapshot database, it is so fast.

    Yup. Do you know why it's so fast?

    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