ESCAP On Premise System Automatically Create DB Backup in the server

ESCAP On Premise System Automatically Create DB Backup in the server

Every day any moment/s can get the backup. just want schedule a task in windows. 

In the schedule task create a batch file to run following SQL script.

sqlcmd -S "Server Name" -i E:\ESCAP-Config\ESCAP_Create_Backup.sql

SQL Script

DECLARE @BackupFile varchar(255), @DB varchar(30), @Description varchar(255), @LogFile varchar(50)
DECLARE @Name varchar(30), @MediaName varchar(30), @BackupDirectory nvarchar(200) 

-- SET YOU BACKUP DIRECTORY HERE:
SET @BackupDirectory = 'Location where to keep ESCAP-Backup\'
--
-- SET YOUR DATABASE NAME HERE:
SET @DB = 'Escap'
--
SET @Name = @DB + '( Daily BACKUP )'
SET @MediaName = @DB + '_Dump' + CONVERT(varchar, CURRENT_TIMESTAMP , 112)
SET @BackupFile = @BackupDirectory + + @DB + '_' + 'Hotel Holidex code' + '_' + 
    CONVERT(varchar, CURRENT_TIMESTAMP , 112) + '.bak'
SET @Description = 'Normal' + ' BACKUP at ' + CONVERT(varchar, CURRENT_TIMESTAMP) + '.' 
SET @BackupFile = @BackupDirectory + @DB + '_' + 'Hotel Holidex code' + '_' + 
    CONVERT(varchar, CURRENT_TIMESTAMP , 112) + '.bak'
SET @Description = 'Full' + ' BACKUP at ' + CONVERT(varchar, CURRENT_TIMESTAMP) + '.' 

BACKUP DATABASE @DB TO DISK = @BackupFile 
WITH NAME = @Name, DESCRIPTION = @Description , 
MEDIANAME = @MediaName, MEDIADESCRIPTION = @Description , 
STATS = 10

Buy making schedule task in the server, at that time the batch file & after script will be run automatically, & back will be save in the given location. 

Just check for next day whether backup is available or not, if available it will keep that forever. 

contact q2 for any inquiry @escap.support@q2solutions.com.au.

    • Related Articles

    • ESCAP On Premise System Automatically DELETE DB Backup from the server to get FREE spaces

      This can be done simply by deleting the backup file from the server folder. However, need attention, do not delete all the backup, just keep recent day or week backup for future needs. Also can make this happen automatically by running a script file ...

    • General - Notes for ESCAP server OS upgrade

      Here are the things to do before and after the server OS upgrade:       1. Before OS upgrade, you need to back up the ESCAP data, ESCAP package and license.       2. After OS upgrade, re install SQL server, restore the data of ESCAP, and re-install ...

    • ESCAP on-premise compared to ESCAP Cloud

      CATEGORY ESCAP ON-PREMISE ESCAP CLOUD TECHNOLOGY, SERVER and INSTALLATION Accessible only at hotel premises Hotel IT team required for all updates Hotel is required to provide a server, IT resources, backups, etc. Hotel IT needs to install ...

    • Escap on premise -How to create yearly budget

      Introduction Each year, around October or November, you can prepare the next year’s budget for the hotel. The Yearly Budget contains both Operational and Financial information. You may need to get some of this information from your Finance/Accounts ...

    • Sidekick and Escap Technical Requirements

      Overview Q2 Solutions software solutions are cloud applications running on Amazon Web Services. To use our core solution, you are only required to have an internet connection, and a supported internet browser, with a recommended screen resolution. Q2 ...