Post reply

Database Snapshot

  • February 15, 2013 at 2:03 am

    #270227

    Hi Experts,

    One of our team member is suggesting to create database snapshot before doing application install so that if something goes wrong in db values also we can revert back from snapshot,i agree with him on data changes but what if any other changes happen or if database gets corrupted?

    Normally we will restore the backup if application installation fails.

    Can anyone point me any issue if we go with database snapshot? We will deleting the snapshot after installation

    Thanks in Advance

  • February 15, 2013 at 2:09 am

    #1588233

    I do both, ensure I have a backup and log chain, and do a snapshot, its much quicker to restore from snapshot than backup.

    Restoring from snapshot reverts everything you have done, DML & DDL.

    If you get corruption, then you just restore from backup.

  • February 15, 2013 at 2:31 am

    #1588242

    Thanks Anthony

  • February 15, 2013 at 6:15 am

    #1588281

    is it possible to recover the source database which got corrupted by some means by using its snapshot?

Viewing 4 posts - 1 through 3 (of 3 total)

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