Page History
Virtual Database (VDB) is a powerful solution that lets you attach SQL Server backup files and query them like real databases. Virtual database Database allows you to gain instant access to critical data in a backup file without spending the time and storage previously required for restore. In minutes, you can create a virtual database and then use any native SQL Server or third-party tools to query and extract the data you need.
Any operation that you can perform on a physical database can be performed on a virtual database. Likewise, applications that rely on getting information from this database can continue using the virtual version. You can also access this virtual database using Microsoft SQL Server tools, such as Management Studio, and other third-party applications.
To obtain more information about VDB, check SQL Virtual Database.
| Tip | title | Important
|---|
You can modify the data and objects in the virtual database. However, because the virtual database is based on archived data, your changes will not persist when you recreate detach the same virtual database later. To preserve your changes, back up backup the modified virtual database and then create a new virtual database using those backup files. |
Virtual Database offers the following features:
Virtual recovery
Provides instant, feature-rich access to all data from within SQLsafe SQL Safe backup and native SQL Server backup files.
...
Allows virtual databases to be quickly and easily created, edited, or removed.
No impact
...
on production servers
Installs to a single non-critical server and attaches all virtual databases to a single SQL Server instance.
When you select the Virtual Database tab the following actions display in the main window:
| Children Display |
|---|
| Note |
|---|
SQL Safe is ONLY compatible with IDERA Dashboard version 4.6 and with limited support. |
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
...