USE master; -- Replace with your actual database name
-- Specify the backup file path
DECLARE @BackupFilePath NVARCHAR(255);
DECLARE @DATE VARCHAR(10)=FORMAT(GETDATE(),'yyyyMMdd')
SET @BackupFilePath = '/var/www/html/projects/medverz/web/Backup/BaitnaV2DB_158-101-245-113_'+@DATE+'.bak'; -- Replace with the desired backup file path
-- Perform the database backup
BACKUP DATABASE BaitnaV2Db TO DISK = @BackupFilePath WITH FORMAT;
