USE master

GO

DECLARE @isicore_backup_dir nvarchar(150) = 'C:\Backup\';
DECLARE @isicore_db_name nvarchar(100) = 'managesoft';
DECLARE @isicore_backup_name nvarchar(250) = 'managesoft_backup';

SELECT @isicore_backup_name =
@isicore_backup_dir + @isicore_backup_name + '.bak';
BACKUP DATABASE @isicore_db_name
TO DISK = @isicore_backup_name
WITH FORMAT,
MEDIANAME = @isicore_db_name, NAME = @isicore_db_name;
