Restore a database backup from an existing SQL script.
You cannot load a database backup that was created on a
different operating system, or with an earlier version of Adaptive Server.
- In the left pane of the Administration Console, expand .
- Select one of:
- User Databases
- System Databases
- Archive Databases
- In-Memory Databases
The Restore wizard is unavailable if you choose:
- Temporary Databases
- Proxy Databases
- In-Memory Temporary Databases
- Right-click the Name field of the database to back up.
- Click the arrow and select Restore to
start the Restore Database wizard.
- In the wizard's Introduction screen, choose Restore using
script.
- On the Script page, you can:
- Enter the syntax for your restore command in the text
field
- Click Select script file... to import an existing SQL
file from a local machine that includes the restore command.
The command from your SQL file then populates the text field.
- (Optional) Choose Summary from the left pane to see the summary of your restore
command, including:
- Database name
- Type of restoration
- Script name
- Click Finish to begin restoring the database.