Use the Map Generation CLI action prepares your backups for future data retrieval.
You can use this CLI action to automatically generate virtual data files for specific backups on a routine basis. For example, you can schedule a SQL Server job that searches for new backup files and then generates the corresponding virtual data.
By building the virtual data before attempting to attach the backup file, you can decrease the time required to create the virtual database and get faster access to your data and objects. The larger the database is, the more time you can save by preparing your backups. For more information about virtual data files, review how SQL Virtual Database works.
Consider running this action on backups for mission-critical and sensitive databases, as well as databases that often require object recovery and data retrieval.
You can specify any of the following options:
To see a detailed description of each option, enter sqlvdbcmd Map
at the command prompt.
You should use the Map Generation CLI action whenever you need to decrease the time required to create a virtual database. Consider using this action for the following types of backups:
Note that you can run this CLI action manually by opening the Windows Command Prompt, and then typing the appropriate command when the prompt displays.
To run the Map Generation CLI action in a job:
sqlvdbcmd Map 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 |
---|