SQL VDB 2.0 and later includes a new command line interface (CLI) that offers new functions and replaces the previous Map Generation utility.
If you are upgrading from SQL VDB 1.x to SQL VDB 2.0 or later , you must update any SQL jobs that use the previous SQLvdbCLI commands. Starting with SQL VDB version 2.0, all SQLvdbCLI commands have been obsoleted.
Use the following table to identify which SQLvdbCLI commands you will need to replace with new CLI actions. For detailed descriptions and available options, see the CLI Help (sqlvdbcmd Help action).
Command | Corresponding command for 2.0 and later |
---|---|
SQLvdbCLI | sqlvdbcmd |
-Create | Create |
-Update | Update |
-Remove | Remove |
-Cleanup | Cleanup |
-EncryptWindowsPassword | EncryptWindowsPassword |
None available | EncryptSqlPassword |
None available | EncryptRestorePassword |
-List | None available |
SQLvdbMapGen | Map |
CLI commands for 1.x
SQL VDB CLI actions and options are not case-sensitive. |
The Map Generation utility was used with SQL VDB versions 1.x. This utility has been replaced by the Map Generation CLI action that is included with the SQL VDB CLI.
sqlvdbmapgen -BackupFile MyFolder\MyBackupFiles\Name.bak -WindowsUsername targetdomain\account -WindowsPassword password
sqlvdbcmd Map MyFolder\MyBackupFiles\Name.bak -WindowsUsername targetdomain\account -WindowsPassword password
You can use SQL Server Agent jobs to groom (delete) unused data files associated with your virtual databases.
sqlvdbcli -Cleanup
sqlvdbcmd Cleanup
You can use SQL Server Agent jobs to prepare backup jobs for future restoration as a virtual database.
sqlvdbcli -Create -Database MyNewVirtualDB -Full MyFolder\MyBackupFiles\Name.bak -InstanceName TargetServer -WindowsUsername targetdomain\account -WindowsPassword password
sqlvdbcmd Create VirtualDatabaseName MyFolder\MyBackupFiles\Name.bak -WindowsUsername targetdomain\account -WindowsPassword password
Need more help? Search the Idera Customer Support Portal
Idera Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
---|