February 1, 2018

In order to create a Snapshot of your database, you can use the following code: DECLARE @DBName VARCHAR(100) = ‘DBName’DECLARE @CurrentDate VARCHAR(20)SET @CurrentDate = ‘_’ + CONVERT(VARCHAR(20), GETDATE(), 120)SET @CurrentDate