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... Continue Reading →
This post refers to an older version of this procedure. Please see HERE for the latest version. 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... Continue Reading →
This post refers to an older version of this procedure. Please see HERE for the latest version. sp_Snapshot is a procedure that we've written to quickly and easily create a database snapshot of one or multiple databases. Prerequisites sp_Snapshot uses STRING_SPLIT, if you're running on a version of SQL Server prior to 2016 or have... Continue Reading →
SQL Undercover 