Database Backup/Restore Wizard
Updated in 2023.1
Microsoft SQL Server only
The Database Backup/Restore Wizard helps you protect your Alloy Navigator database by creating backup files. Backing up your database regularly is recommended to prevent potential data loss in case of hard drive crashes or other failures.
Before starting to restore a database, make sure all users are logged off from Alloy Navigator; otherwise, the restore operation will fail.
To start the Database Backup/Restore wizard:
-
Launch
dbBackup.exe, located in the/Binfolder under your Alloy Navigator installation folder.
The wizard includes the following pages:
- Action to perform
- Specify the target server and choose the database to back up
- Backup location
- Ready to backup
- Backup completed
- Specify the target server and database
- Restore location
- Restore options
- Ready to restore
- Completed
You can use the Database Backup/Restore Wizard to copy an Alloy Navigator database from one SQL server to another by taking the following steps:
-
Use the wizard to back up the database on the source SQL server.
-
Copy the backup file to the destination SQL server.
-
Use the wizard to restore the database on the destination SQL server.
NOTE: Alternatively, you can back up and restore your database by using Microsoft SQL Server management tools.
The Database Backup/Restore Wizard has a command-line interface, so you can automate it.
INFO: For instructions, see Command-line options for the Database Backup/Restore Wizard.