Skip to content
  • There are no suggestions because the search field is empty.

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;