Database Restore Wizard
ShareScan provides a quick and easy way to restore databases by using the Database Restore Wizard, accessible via the Administration Console. To restore a database, follow the steps below.
- Click the Restore Database Wizard menu item. The Welcome screen appears.
- Click Next. The Specify destination server dialog appears.
- Select the server to be restored.
- Enter the username / password to access the server. Note that the user account must have administration (sa) rights on the target server, as a database is created and set to Trustworthy during the restore process.
- Click Test connection to check the supplied credentials.
- Click Next. The Select backup file to restore dialog appears.
- Enter the folder path and file name of the backup file you want to restore. Note that the file has to be located on the computer itself running the SQL Database Server that is the target of the restore operation. That is, if you restore the database to a local SQL Server, the backup file can be on this machine, but if you want to perform the restore on a remote server, you have to ensure that the Backup file is on that remote server, and you have to specify the path of the backup file on that server.
- Click Start. The Results screen appears.