Create a database backup query with dynamic names in sql server

Uncategories Create a database backup query with dynamic names in sql server

declare @filenamedbbc varchar(200)

set @filenamedbbc= 'DB' +replace(convert(varchar, getdate(),101),'/','') + replace(convert(varchar, getdate(),108),':','')+'.bak';

BACKUP DATABASE [sncc] TO DISK = @filenamedbbc WITH NOFORMAT, NOINIT, NAME = N'DB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10