Skip to main content

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'"