Configure an instant access database
When you configure an instant access database, you can choose to add the database automatically to the instance. Or, you can export the database to a Samba share.
To configure an instant access database and automatically add the database to the instance, you can use a full, incremental, or transaction log backup.
To configure an instant access database and then start the database
- On the left, click Workloads > 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.
- Locate 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 credentials for the recovery target. Or, click Select existing credentials to select the credential you want to use.
The user account must be a member of the Windows administrator group and a member of the local SQL Server sysadmin role.
- Click Next.
- 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.
To configure an instant database and export the database to Samba share, you must use a full backup.
To configure an instant access database, but not start the database
- On the left, click Workloads > 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.
- Locate 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.