Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

...

To access the SQL VDB CLI, start the Windows Command Prompt, and then enter sqlvdbcmd to see which commands and options you can use. For more information about the SQL virtual database components, see the product components .

About virtual databases

A virtual database (vdb) is a patent-pending software implementation of a database that allows for data storage and retrieval like a physical database.

...

Each SQL Server instance can host multiple virtual databases.

What you can do with a virtual database

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 use the built-in query tool to execute commands on objects in this virtual database. You can also access this virtual database using Microsoft SQL Server tools, such as Management Studio, and other third-party applications. For more information, see our Tips and tricks .

Info

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 the same virtual database later. To preserve your changes, back up the modified virtual database and then create a new virtual database using those backup files.

...