Press "Enter" to skip to content

Taking Database Snapshots with sp_snapshot

David Fowler updates an older procedure:

Presenting you with an updated version of our sp_snapshot procedure, to easily create database snapshots.

This new version adds more flexibility to the procedure, allowing you to specify the snapshot’s suffix, add a timestamp and alter the path that the snapshot files are taken to.

Read on for the procedure text and an example of how to call it.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.