1DECLARE @name VARCHAR(50) -- database name 2DECLARE @path VARCHAR(256) -- path for backup files 3DECLARE @fileName VARCHAR(256) -- filename for backup 4DECLARE @fileDate VARCHAR(20) -- used for file name 5DECLARE @debug BIT = 0 6 7-- specify database backup directory 8SET @path = 'c:\temp\db-backup\' --must …
Read MoreStored procedure for backuping all databases in a MSSQL-database. 1 2DECLARE @name VARCHAR(50) -- database name 3DECLARE @path VARCHAR(256) -- path for backup files 4DECLARE @fileName VARCHAR(256) -- filename for backup 5DECLARE @fileDate VARCHAR(20) -- used for file name 6 7SET @path = 'C:\Backup\'; 8 9SELECT …
Read More