Skip Navigation LinksALVAO 10.1ALVAO Asset ManagementSystem Implementation in an OrganizationDatabase Backup Skip Navigation Links. Skip Navigation Links Skip Navigation Links.


Database Backup

Perform a regular backup of your database, using common database backup tools in the MS SQL Server. It is recommended to back up the database on a daily basis, outside of main system operating time.

Scheduling Backup in MS SQL Management Studio

  1. Launch Microsoft SQL Server Management Studio.
  2. Connect to the SQL Server, go to the Navigation Pane on the left and select the Management – Maintenance Plans folder. Right-click on the folder and select New Maintenance Plan.
  3. Next, follow the steps of the Wizard and create a task for ALVAO database backup.

Using Command Line for Backup

You can also use the command line to back up your database, e.g. as part of a scheduled task on the server.

Example of the 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.