Skip Navigation LinksALVAO 11.2Admin guideOn-premises installationDatabase backup Skip Navigation Links.


Change Alvao version
Change language
Skip Navigation LinksALVAO 11.2 / Admin guide / On-premises installation / Database backup

Database backup

Backup the database regularly using common means for backing up databases on MS SQL Server. It is recommended to back up the database every day during off-peak hours.

Scheduling backups from MS SQL Management Studio

  1. Start Microsoft SQL Server Management Studio.
  2. Connect to SQL Server and select the Management - Maintenance Plans folder in the left navigation bar. Right-click on the folder and select New Maintenance Plan.
  3. Follow the wizard to create a backup task for your Alvao database.

Backup from the command line

You can also run a database backup from the command line, e.g. as part of a scheduled task on the server.

Example command line:

sqlcmd -S sql_server_name -Q "BACKUP DATABASE database_name TO DISK = 'C:\Backup\alvao.bak'"

 

Did not find what you were looking for? Ask our technical support team.