Configure an instant access database
You can configure an instant access database from a full, a transaction log, or an incremental backup. You can choose to add the database automatically to the SQL Server instance.
To configure an instant access database and then start the database
- On the left, click Microsoft SQL Server.
- On the Databases tab, click the database for which you want to configure the instant access database.
- Click the Recovery points tab, then click the date on which the backup occurred.
The available images appear in rows with the backup timestamp for each image.
- Right-click on the backup image and click Actions > Configure instant access.
- (Conditional) For a full backup, after the instant access database is created you can add the database to the instance and start the database. Click Yes > Next for this option.
- (Conditional) For a transaction log, select a replay option and click Next.
- Review the recovery target and host name, instance name and make any wanted changes.
To change the host and instance, click Change instance.
- In the Database name field, enter the instant access database name that you want to create.
- Enter the username and password of the SQL Server instance for the recovery target.
- Review the recovery options and make changes if needed and then click Next.
- (Optional) To view a list of the backup images for the selected recovery point, click the link that displays the number of backup images.
- Review the summary of the selected recovery target and recovery options. Then click Start recovery.
- After the instant access job starts, you can click on the Restore activity tab to view the progress.
See View the livemount details of an instant access database.
You can configure an instant access database from a full backup. If you do not want to start the instant access database after it is created, you can enter the host name or select the name where you want to create the instant access database. After the instant access database is created, the database is not added to the instance but exported to a Samba share.
To configure an instant access database, but not start the database
- On the left, click Microsoft SQL Server.
- On the Databases tab, click the database for which you want to configure the instant access database.
- Click the Recovery points tab, then click the date on which the backup occurred.
The available images appear in rows with the backup timestamp for each image.
- Right-click on the backup image and click Actions > Configure instant access.
- If you want to add the database to the instance and start the database, choose No > Next.
- Select one of the following options for the recovery target:
To enter the recovery target host name, click Enter host name.
To select from a list of hosts, click Select host name
- (Optional) To view a list of the backup images for the selected recovery point, click the link that displays the number of backup images.
- Click Start recovery.
- After the instant access job starts, you can click on the Restore activity tab to view the progress.
See View the livemount details of an instant access database.