- Immediate access - get data from backup files instantly
- Acts like a real database - Use 3rd party and native tools
- OLR replacement - better solution to object level recovery
- Multiple Uses - reporting, data extraction, analysis, etc.
- Read/Write support - inserts, updates, DBCC commands
Immediate Data Retrieval
Gain instant access to data in a backup file without wasting the time or storage necessary to restore the database. Creating a virtual database from a full native or SQL safe backup is a simple three step process and takes just a few minutes.
Use with 3rd party tools
It looks, acts, and behaves like an actual live database; even SQL Server doesn’t know the difference. Simply attach the backup file, and use any native SQL Server or third party tools to query and extract the data you need.
OLR Replacement Solution
Object level recovery takes time, doesn’t support all the backup file types (e.g. full, differential, or transaction log files) nor does it support recovery of all objects. SQL virtual database does support these needs, is more accurate and goes beyond just OLR. From database troubleshooting to data extraction, the uses are many.
Use SQL virtual database for a whole host of maintenance activities, including: verifying the integrity of a backup, checking for database consistency, checking for index fragmentation, testing or verifying code changes, and many more.
SQL virtual database provides complete support for read and write operations, including inserts, updates, deletes, DBCC commands, and other maintenance operations.