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. Parameters @DatabaseList – a comma delimited string of database names,... Continue Reading →
Finding a History of Database Snapshots, Taken and Restored
All code in this post can be found in our GitHub repo https://github.com/SQLUndercover/UndercoverToolbox This is a question that's come up twice this morning, firstly where can we find a history of database snapshots and secondly where can we find a history of restores from snapshot? Frustratingly, SQL doesn't make this at all easy for us... Continue Reading →
Get All Database Snapshots and Their Parent Databases On A SQL Server
This is going to be a quick post but this morning I was asked the question, 'how can I get the name of all the database snapshots on a SQL Server?'. It was an interesting question so I thought I'd share a quick script to do just that. We're going to need to tap into... Continue Reading →
UNDERCOVER TOOLBOX: sp_Snapshot – The Easy Way To Create Database Snapshots for One or Many Database
This post refers to an older version of this procedure. Please see https://sqlundercover.com/2024/02/01/sp_snapshot-the-easy-way-to-take-database-snapshots-of-one-of-more-databases-version-2-0/ 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 →