T-SQL Script: Backup with Date-Time Stamp
T-SQL Script: Backup with Date-Time Stamp
DECLARE @DatabaseName NVARCHAR(128) = 'YourDatabaseName';
DECLARE @BackupPath NVARCHAR(260) = 'C:\SQLBackups\';
DECLARE @DateTimeSuffix NVARCHAR(20) =
FORMAT(GETDATE(), 'yyyyMMdd_HHmmss');
DECLARE @BackupFileName NVARCHAR(260) =
@BackupPath + @DatabaseName + '_' + @DateTimeSuffix + '.bak';
BACKUP DATABASE @DatabaseName
TO DISK = @BackupFileName
WITH INIT, COMPRESSION, STATS = 10;
DECLARE @BackupPath NVARCHAR(260) = 'C:\SQLBackups\';
DECLARE @DateTimeSuffix NVARCHAR(20) =
FORMAT(GETDATE(), 'yyyyMMdd_HHmmss');
DECLARE @BackupFileName NVARCHAR(260) =
@BackupPath + @DatabaseName + '_' + @DateTimeSuffix + '.bak';
BACKUP DATABASE @DatabaseName
TO DISK = @BackupFileName
WITH INIT, COMPRESSION, STATS = 10;