Backup SQL Server

script-backup.sql

DECLARE @FileName AS VARCHAR(30), @FullPath AS VARCHAR(200), @Database sysname; 

SET @Database = 'MyDatabaseName';
 
SET @FileName = CONVERT(VARCHAR(30), GETDATE(), 20);
SET @FileName = REPLACE(@FileName, '-', '');
SET @FileName = REPLACE(@FileName, ' ', '');
SET @FileName = REPLACE(@FileName, ':', '');
SET @FileName = @Database + '_' + @FileName + '.bak';
 
SET @FullPath = 'C:\MyBackups\Path\' + @FileName;
 
BACKUP DATABASE @Database TO DISK = @FullPath;