On the Virtual Database tab, you can see all the existing Virtual Databases in your environment. Create virtual databases to access, compare, recover, and report on data from previous backups of databases.
For each Virtual Database, you can see the following information:
- Status - displays the status (Online, Restoring, Recovering, Recovery Pending, Suspect, Emergency, Offline, Server Offline, Creating Content Map, Creating, Created Failed, License Expired, Detached, Unknown) of the Virtual Database.
- Instance - displays the name of the SQL Server instance under which the Virtual Database is mounted.
- Database - displays the name of the Virtual Database.
- Point in Time - displays the date and time when the Virtual Database was restored.
- Backup Files - displays the backup file where the Virtual Database is mounted.
- Description - details the description specified when mounting the Virtual Database.
- Actions - click the
gear icon to:- Edit - edit the Virtual Database options.
- Edit/Add description - enter and/or edit the description of the Virtual Database.
- Remove - remove the Virtual Database.
Keep in mind:
- You can sort the information available on this tab by clicking the column header by which you want to order your instances.
- You can set the number of items you want to view per page by going to the lower section of the list grid, type a number in the box, and the page will be updated according to your requirements.
How can you filter your information?
In order to get more specific Virtual Database information from your environment, you can use the Filtering section on the left side of the Virtual Database tab. You can filter your information by:
- Status - select a status (Online, Restoring, Recovering, Recovery Pending, Suspect, Emergency, Offline, Server Offline, Creating Content Map, Creating, Created Failed, License Expired, Detached, Unknown) to filter your Virtual Database.
- Instance Name - type the name of the SQL Server instance under which the Virtual Database is mounted. You can use the WildCards (&, ^, [], %, and _).
- Databases Name - type the name of the Virtual Database. You can use the WildCards (&, ^, [], %, and _).
When using filters take into account:
- You can save your filtering options by selecting your filters, typing a name in the By Custom Filter field, and clicking Add Filter. To retrieve your saved filters, click the drop-down option in the By Custom Filter section and select your filter name.
- If you want to select filters first and apply the changes later, deselect the Apply filter as it changes option.
- To remove filters, use the specific Remove Filter option in each filter. For example, if you want to remove your Status filters, click Remove Status Filter under the same filter section.
- Under APPLIED FILTERS on the top section or your Virtual Databases tab, you can see the filters you have selected. Click the X icon next to the ones you want to remove.
- Use the option Clear on the top section of the Filtering section to remove all filters.
What other options are available on the Virtual Database tab?
On the top section of the Virtual Database tab, you can find the following options:
- Atthach Full backup - use this option to create a Virtual Database from a single full backup file. Visit the Attach Full Backup section to find more information.
- Attach Multiple Backups - use this option to create a Virtual Database based on data from specific backup files. Visit the Attach Multiple Backups section to find more information.
- Remove - use this option to remove a Virtual Database. For more options visit the Remove a Virtual Database section.
- Refresh
- use this option to refresh your Managed Virtual Databases section.