Publishing databases allows you to temporarily attach large SQL databases to the target Microsoft SQL server without having to actually restore them.
Publishing databases typically occurs faster than using standard restore features and might be convenient in certain cases, for example, when your time to perform disaster-recovery operations is limited.
During publishing, Veeam mounts VMs disks from the backup file to a target machine (under the C:\VeeamFLR directory), retrieves required database files and attaches associated databases directly to your SQL server so that you can perform required operations using Microsoft SQL tools such as Microsoft SQL Management Studio.
Consider the following:
- Publishing multiple databases at the same time is not supported.
- You can publish the same database more than once.
Mind that when a database that is already published is being republished with the same name, then all the changes that have been made to this database will be lost on a target SQL server, as it will be published anew.
- After you unpublish a database, Veeam Explorer detaches such a database from a target SQL server but the restore restore point will continue to remain on a target machine for the next 15 minutes.
- If a Veeam Explorer session has been terminated in any way other than by clicking Exit in the main menu (or by clicking the X button at the top-right corner), then all the published databases will continue to remain attached to the target SQL server having the Recovery pending state.
- If published databases have been manually renamed via SQL tools (for example, in Microsoft SQL Management Studio), then Veeam will not be able to unpublish such databases properly. In this case, all the renamed databases will continue to remain attached to the target SQL server and you will have to remove them manually using SQL tools.
- Databases cannot be published to a SQL cluster.
- Published databases are ignored during backup.
- Upon closing the Veeam Explorer console, all the published databases will be detached from the target SQL server automatically. The corresponding mount points will also be dismounted from under the C:\VeeamFLR directory.
In This Section
- Publishing to Specified Server
- Publishing Latest or Point-in-Time State
- Publish Point-in-Time State
- Publish Latest State
- Unpublishing Databases
- Exporting as BAK
- Refreshing Database Status