Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hardik Doshi SSMS & Database snapshot RE: SSMS & Database snapshot

  • December 3, 2010 at 8:08 am

    #1258429

    Patrick2525 (12/3/2010)

    Within SSMS, click on Replication -> Publications, right click -> New Publication, and follow the wizard for either a Merge or Snapshot replication, and a snapshot will be created! I'd say that SSMS supports that quite well since you don't even need to know any T-Sql!

    Don't get the two snapshots mixed up. Database Snapshots are not the same thing as Replication Snapshots.

    Replication Snapshots are designed to create a base for publications and future replication activities. They don't even necessarily have to have all the data from a database to do this. Just the data that's published in publications and articles. You can't restore from a Replication Snapshot.

    Database Snapshots are a sparse file. They designed to hold old data that has recently changed in your source database and they can be restored from. You can't replicate from a Database Snapshot.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.