Page History
...
To mount a virtual database use the following command that helps you create a new virtual database:
- SQLvdbCmd Create SQLsafeCmd MountVDB <db_name> <backup_archive> [options]
...
Action | Description |
---|---|
<db_name> | Name of the database. |
<backup_archive> | Path to the backup archive. |
Common Options
The following options help you create a new virtual database:
Options | Descriptions |
---|---|
-BackupSet <index> | <index> - the index of the backup set within the backup archive. (1-based). |
-DisconnectUsers | Disconnects all users from the target database before the restore operation begins. |
-EncryptedRestorePassword <pwd> | <pwd> - the encrypted password used to decrypt the backup. |
-InstanceName <name> | <name> - SQL server instance name. Note: it is not required if the instance is set as a default on the target server. |
-Move <logical_filename> <target_filename> | To move the database logical database file to the physical target file. <logical_filename> - the database logical database file. <target_filename> - the physical target file. Corresponds to the WITH MOVE option in the RESTORE DATABASE T/SQL command. |
-Password <pwd> | <pwd> - the non-encrypted password used to encrypt the backup. |
-Server <hostname> | <hostname> - the hostname of server hosting the SQL Server where the operation should be performed. Note: this option is required for accessing remote or clustered SQL Servers (where applicable). |
-Replace | Overrides database if exists. |
Security Options
Secure your operations with the following options:
Options | Description |
---|---|
-NoPrompt | Never prompt for credentials even if necessary. |
-SecurityModel <model> | The security model used to log into SQL Server. <model> - {Integrated, SQL}. Note: Integrated (Windows authentication) is the default. |
-SqlUsername <username> | <username> - the SQL Server username. (SQL SecurityModel). |
-SqlPassword <pwd> | <pwd> - the SQL Server password. (SQL SecurityModel). |
-EncryptedSqlPassword <pwd> | <pwd> - the encrypted SQL Server password generated by EncryptSqlPassword action. (SQLSecurityModel). |
-WindowsUsername <domain\user> | <domain\user> - the Windows user that will be used to read/write the backup archive. |
-WindowsPassword <pwd> | <pwd> - the password for the Windows user. |
-EncryptedWindowsPassword <pwd> | <pwd> - the encrypted password for the Windows user generated by EncryptWindowsPassword action. |
Advanced Options
The following advanced options help you create a new virtual database:
...
For detailed descriptions and available options, see the CLI Help (SQLvdbCmd SQLsafeCmd help MountVDB
).