Help Center
Choose product document...
Veeam Backup & Replication 9.5 Update 4
Veeam Explorers User Guide

Data Publishing

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 the target SQL server but the restore point will continue to remain on the 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 in the upper-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 the 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

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Agent Management Guide

Veeam Explorers User Guide

Backup and Restore of SQL Server Databases

Veeam Plug-ins for Enterprise Applications

PowerShell Reference

Veeam Explorers PowerShell Reference

RESTful API Reference

Required Permissions

Veeam Availability for Nutanix AHV

Veeam Backup for Microsoft Office 365 Documentation

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation