NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Template Scripts > Util > Backup Util and DBA

Template Script: Util\Backup Util and DBA.sql

SET NOCOUNT ON
SELECT
'BACKUP DATABASE [Util] TO DISK = N''H:\Backup\Util_' + dt + '.bak'' WITH NOFORMAT, INIT, NAME = N''Util-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO
BACKUP DATABASE [DBA] TO DISK = N''H:\Backup\DBA_' + dt + '.bak'' WITH NOFORMAT, INIT, NAME = N''DBA-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO
BACKUP DATABASE [DiabloSynch] TO DISK = N''H:\Backup\DiabloSynch_' + dt + '.bak'' WITH NOFORMAT, INIT, NAME = N''DiabloSynch-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO
' FROM (SELECT CONVERT(VARCHAR(10), GETDATE(),112) AS dt) d

Description for Template Script: Util\Backup Util and DBA.sql

Todo