Page History

This build of SQL Admin Toolset Virtual Database includes many fixed issues, including the following updates.

1.6 New features

SQL Server 2012 support

The tools available in the SQL Admin Toolset now support SQL Server 2012.

1.5 New features

New Linked Server Copy tool

The new Linked Server Copy tool lets you quickly and easily copy our Linked Servers from one SQL Server instance to another along with the associated settings, logins, passwords, and permissions.

New options for the Quick Re-Index tool

The Quick Re-Index tool now allows you to:

• Specify which fill factor you want to use when the selected index is rebuilt.
• Enable online processing during rebuild.
• Use the Maxdrop setting to specify he maximum degree of parallelism to use during the rebuild.

1.5 Fixed issues

Index Analyzer

You can now view a list of columns of an index in the order that they were defined.

Patch Analyzer

Patch Analyzer now includes the latest SQL Server service packs.

Multi Query

• Multi Query now correctly sorts the returned results.
• You can now use multi-line strings when performing a query.

Space Analyzer

The Space Analyzer tool now correctly reports the value for the Maximum Potential Size metric.

1.3 Fixed issues

Job Editor

You can now successfully retrieve job information from a server group that contains duplicate SQL Server instances.

Job Mover

You can now successfully move SQL Server jobs whose names contain single quote marks (').

Multi Query

You can now successfully clear the returned results of your query from the Query Execution and Results pane.

Server Groups

Special characters are no longer supported when naming new SQL Server groups. Support does continue for existing server groups which were created by SQL Admin Toolset version 1.2 or earlier, that contain special characters.

SQL Search

You can successfully search for text strings in a SQL Server job even if the MSDB system database is not listed in your search criteria.

1.2 Fixed issues

General

• This release offers full support for SQL Server 2008.
• You may now browse and select databases on a single server. Multiple databases on server groups must be added manually.
• All server browse lists include any servers defined in server groups.
• You can copy error reports to the clipboard.

Connection Check

Windows Authentication field allows a connection test to be run under an alternate user account.

Database Configuration

Added a new comparison report.

Database Mover

• Database Mover now supports database clusters.
• When moving a database, you have the option to set the default database for all of the migrated users to be the matching databases on the destination server.
• When a database is moved, the database owner is also copied to the destination server.
• When selecting a destination, you can browse to servers on different drives.
• A database can be renamed and copied to the same server instance.

Index Analyzer

You can select individual or multiple databases before running the Index Analyzer.

Inventory Reporter

Server Inventory now includes fields for: TCP Port Setting, Memory Allocation Type, Minimum SQL Server Memory, Maximum SQL Server Memory, Allocated CPU Count, Allocated CPU Count I/O, Number of Physical Processors, Number of Logical Processors, and a list of enabled SQL Server Network Libraries.

Job Mover

Moving jobs with multiple steps no longer causes an error.

Partition Generator

Viewing details of a partitioned table no longer generates an error message.

Password Checker

• Results can be exported as a TXT, CSV, or XML file.
• Results show the servers tested, the number of logins tested, bad passwords, blank passwords, and passwords that match the login.
• Additional password dictionaries have been added to the default list.
• You may select multiple dictionaries to use simultaneously.

Patch Analyzer

Results are sorted by SQL Server name, and can be further sorted by column within each group.

Quick Reindex

• The index results are no longer automatically resorted after reindexing.
• You have the option to turn off the reindexing warning message.
• You can select individual databases before loading index statistics.

Server Configuration

• Configuration information now includes service pack level, server collation, and login audit information.
• Comparison results now display differences in server collation values. These differences cannot be updated.

Server Ping

You can now start, stop, pause, resume, and restart SQL Server instances.

Server Statistics

• The server state is now correct for SQL Server 2000.
• The results for per-second counters (e.g. logins/sec) are more accurate.

Space Analyzer

• The Space Analyzer tool now has the ability to display space information for local mount points. However, it only detects mount points on Windows 2003, 2008, and Vista, and the mount point must host a valid database.
• Results now include system databases (e.g. tempdb, msdb).
• Results include a new column % Disk Used by Database File showing how much disk space is used by the selected file.

SQL Discovery

When scanning, you may enter a range of IP addresses or a local subnet.

User Clone

2.0.1 Fixed issues

• SQL VDB now successfully creates a virtual database in situations when an incompatibility occurs between the SQL VDB Filter Driver and other third-party drivers, such as CA ArcServe, interacting with the target SQL Server instance.
• SQL VDB now successfully generates the virtual data map when the data files associated with the archived database are located on multiple physical disks that have different data retrieval speeds.
• SQL VDB now successfully creates virtual databases for large backup files stored on a Windows cluster node.
• SQL VDB now correctly excludes deleted data and log files when creating a virtual database.
• SQL VDB now handles NULL values that may be returned from the operating system when a virtual database is being created, allowing the operation to continue.

2.0 New features

New SQL Server 2012 support

SQL Virtual Database 2.0 fully supports the use of SQL Server 2012 RTM.

New support for FILESTREAM enabled databases

Virtual databases can now be created from databases that contain FILESTREAM data.

New support for TDE encrypted databases

Virtual databases can now be created from databases that are encrypted with Transparent Data Encryption (TDE).

Improved support for DBCC CHECKDB

The WITH TABLOCK keyword is no longer required when running DBCC CHECKDB against virtual databases, resulting in a more thorough integrity check and improved performance.

Improved CLI

The SQL Virtual Database CLI syntax has been updated and new commands have been added for greater flexibility.

2.0 Fixed issues

• SQL VDB no longer causes SQL Server Management Studio to return the error “Cannot show requested dialog” when that client tool attempts to display the virtual database properties.
• SQL VDB no longer locks the master database when it creates a virtual database on that target SQL Server instance.
• Virtual database files now include the name of the source backup file, the name of the virtual database, and have the extension .VirtualDatabase. Learn more about virtual database file changes.
• SQL VDB now supports TDE encrypted, native backup files.
• You can now create virtual databases from SQL Server database snapshots.
• SQL VDB now stores virtual database files in the Program Files directory. Learn more about virtual database file changes.
• SQL VDB no longer causes a recovery lock while creating a virtual database. The recovery lock would render the target SQL Server instance inaccessible or make the system databases, such as model, appear corrupted.

1.6 New features

There are no new features in SQL Virtual Database 1.6.

1.6 Fixed issues

• PRBE10811Users no longer receive an error when attempting to read or write to memory using a SQL Safe-generated backup file. This issue was a rare occurrence.
• PRBE10815SQL VDB now allows you to have multiple mounts using the same encrypted backup file as the source.
• PRBE10825SQL Server no longer generates an error message resulting from SQL Server 2000 partially-completed virtual log files returning with no data.
• PRBE10825Users who have SQL Server 2000 databases containing multiple log files no longer receive an incorrect virtual log file number used by SQL VDB as an index to the log file arrays.

1.5 Fixed issues

The Attach Multiple Backups wizard now allows you to select multiple log files without forcing the use of the most closely-related full backup file. You can select an appropriate full backup file, and then freely select from the other available log files that are part of the same LSN chain.

1.4 Service Pack 1 Fixed issues

• A backup of a virtual database can now be successfully restored or used to create another virtual database.
• The Map Generation utility now correctly generates virtual data files for native backups of SQL Server 2008 instances.
• The SQL VDB production license now allows you 14 days to activate the license key before it expires.
• SQL VDB now correctly handles page validation when creating virtual databases.

1.4 Build 44 New features

The SQL Virtual Database Map Generation utility now supports compressed native backups of SQL Server 2008 databases.

1.4 Fixed issues

This release contains the following fixed issues:

• The SQL VDB Engine how correctly detects and handles non-data pages, such as pages containing full-text data, when attaching and searching backup files.
• You can now create a virtual database from a full backup and multiple transaction log backups that belong to an unbroken LSN chain, even when additional full backups were performed during the same time frame as the transaction log backups.

1.3 Fixed issue

SQL VDB now successfully attaches a backup file that had been created when the target database was growing. This issue was most likely to occur when the transactions that caused the database growth affected a GAM page. For more information about GAM pages and database growth, see SQL Server Books Online.

1.2 Fixed issue

When creating virtual databases, the SQL VDB Engine now correctly handles:

• any LOP_BUF_WRITE transactions in the selected backup files

• timeout errors when creating or accessing the virtual data files

1.1 Build 1118 Fixed issue

The SQL VDB configuration files are now encrypted.

1.1 Fixed issues

This release contains the following fixed issues:

• This build provides improved performance and greater stability when creating and querying virtual databases.
• You can now delete a previously attached virtual database using the Console or CLI.
• You can now use an LSN (log sequence number) range to specify a point in time when attaching transaction log backups through either the Console or the CLI.
• The SQL VDB Console now displays the full filename of the selected backup when prompting for the encryption password.
• SQL Virtual Database now provides improved descriptions for events written to the application event logs
• The Default Database field for a new user correctly displays databases from the destination SQL Server.
• Source User displays all Windows authenticated group logins.
You have the option to exclude role-level object permissions
• .

Need more help? Search the Idera Customer Support Portal