Post reply

Snapshot backup

  • July 24, 2011 at 3:12 am

    #254842

    Hi friends,

    why we cannot backup of the snaphot?, there is a reason that we cannot restore it since it is read-only we cannt do that, but what with the backup.. ?? backup will just read the pages of snaphot right?

  • July 24, 2011 at 3:39 am

    #1357517

    The pages of the snapshot however are not an entire database. The only pages in a snapshot are pages that had changed in the source DB since the snapshot's creation.

    To allow a backup of a snapshot, the snapshot and the source DB would have to be read, doing a kinda merge of the two. If that were done, the backup would be restorable as a new database, not as a snapshot.

    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

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

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