Please call us (35210792) for more detail



Please pick one category below or use the search function to search our products.

Idynamic . Media Product Category:

 
 

 
 
System Utilities: Backup/ Storage Solution

2195
Idera SQL virtual database

Access data in SQL backup files without restoring

- 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


1. Why It Rocks

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.

Multiple Uses
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.

Operations Support
SQL virtual database provides complete support for read and write operations, including inserts, updates, deletes, DBCC commands, and other maintenance operations.


2. Enterprise Capabilities

Intuitive Console
The console allows virtual databases to be quickly and easily added, edited, or removed. Open the SQL virtual database in seconds and accomplish tasks more quickly.

Point-in-time Selection
Restore from any point in time; simply select a point-in-time allowing for granular control over the state of the information displayed in the virtual database.

Attach full backups
No backup is too large, attach a full backup and simply select a new name for the SQL virtual database, it shows up just like any other database in SQL Server Management Studio (SSMS).

Attach multiple backups
Choose a series of backups to run queries, reports, and other analysis against. Find out which rows were added, modified, or deleted since the last backup.

Light-weight installation
Quickly and easily install onto a single non-critical system and attach all virtual databases to a single SQL Server instance.


3. Maintenance Activities

Use Case #1
Recover a stored procedure, create DDL script of an entire database, table or data, or view user, role or permissions as of yesterdayˇ¦s backup or any day prior using SQL Server Management Studio

Use Case #2
Identify rows added, modified &/or deleted since last backup using a compare tool

Use Case #3
Recover tables without restoring databases using BCP

Use Case #4
Report on data changes, security and permissions over time using T-SQL

Use Case #5
Run a historical report without restoring databases using SQL Server Reporting Services


4. System Requirements

Console and Services
- Windows XP SP3, Windows Server 2003 SP3, Windows 2008 SP1, Windows Vista SP2+, Windows 7, Windows 2008 R2, Windows 8, Windows 2012
- .NET 2.0 SP2+

Supported SQL Server instances
- SQL Server 2000 SP4, SQL Server 2005 SP1+, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Supported backup file formats
- SQL safe backups 5.0, 6.0, 7.0+
- SQL Server 2000, 2005, 2008, 2008 R2, 2012
- Full, Differential, Transaction Log

Status: Contact Us for Special Price
Manufacturer: Idera
Reference URL http://www.idera.com/productssolutions/sqlserver/sqlvirtualdatabase/



Note: Product information provided above is for reference only. For the detail of the product, please help to visit manufacturer's web site for more information.

If you want to find out more about our products and services,
Please call (852)-35210792 or email to info@idynamicmedia.com.

Copyright 2018 Idynamic Media Company Limited
All Rights Reserved.
Disclaimer