Page History

...

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.

For each job that calls the Map Generation utility, update your code to use the Map Generation CLI action instead:

1. Use Microsoft Management Studio to edit the job.
2. Find and delete this code:
   sqlvdbmapgen -BackupFile MyFolder\MyBackupFiles\Name.bak -WindowsUsername targetdomain\account -WindowsPassword password
3. Enter this new code:
   sqlvdbcmd Map MyFolder\MyBackupFiles\Name.bak -WindowsUsername targetdomain\account -WindowsPassword password
4. Save the job, and then run it manually to validate that it completes as expected.

...

1. Use Microsoft Management Studio to edit the job.
2. Find and delete this code:
   sqlvdbcli -Cleanup
3. Enter this new code:
   sqlvdbcmd Cleanup
4. Save the job, and then run it manually to validate that it completes as expected.

Update jobs that restore backups as virtual databases

You can use SQL Server SQL Server Agent jobs to prepare backup filesjobs for future restoration as a virtual database.

...

1. Use Microsoft Management Studio to edit the job.
2. Find and delete this code:
   sqlvdbcli -Create -Database MyNewVirtualDB -Full MyFolder\MyBackupFiles\Name.bak -InstanceName TargetServer -WindowsUsername targetdomain\account -WindowsPassword password
3. Enter this new code:
   sqlvdbcmd Create VirtualDatabaseName MyFolder\MyBackupFiles\Name.bak -WindowsUsername targetdomain\account -WindowsPassword password
4. Save the job, and then run it manually to validate that it completes as expected.

...