David Fowler announces a tool update:
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily create database snapshots.
This new version fixes a bug that we’ve found in version 2 where snapshots will fail for databases with multiple data files.
We’ve also added the @STMTOnly parameter, allowing you to generate the scripts for creating the required snapshots without actually doing so.
Click through for more information, as well as where you can go to download the script.