Backup an MS SQL database using using a timestamp

backup-mssql-db.sql

DECLARE @dbName nvarchar(max) = '<db_name>'
DECLARE @path nvarchar(max) = '<destination_path>'

DECLARE @date datetime = GETDATE()
DECLARE @timeStamp nvarchar(max) = CONVERT(nvarchar(max), @date, 112) + '-' + REPLACE(CONVERT(nvarchar(max), @date, 108), ':', '')
DECLARE @fileName nvarchar(max) = @path + @dbName + '_' + @timeStamp + '.bak'

BACKUP DATABASE @dbName TO DISK = @fileName

GO