Help Center
Choose product document...
Veeam Backup & Replication 9.5 [Archived]
Veeam Backup Explorers User Guide

Exporting Database Schema and Data to Custom Location

To export database schema and data to the specified location, do the following:

  1. Open Veeam Explorer for Microsoft SQL Server.
  2. In the navigation tree, select the required database and click Export Schema > Export database schema and data ..., using the shortcut menu or use the corresponding ribbon menu command.

Exporting Database Schema and Data to Custom Location 

  1. Proceed to the Step 1. Specify the Restore Point step of the export wizard.

When exporting schema objects, Veeam Explorer for Microsoft SQL Server creates a single .SQL script for all selected objects. To import exported objects, you can run this script on a target database. When exporting data (as tables), Veeam Explorer creates a pair of files (.TXT and .FMT) for each exported table. To import data tables, use the standard SQL Server bcp.exe utility (see https://msdn.microsoft.com/en-us/library/aa337544(v=sql.120).aspx for details).

Exporting Database Schema and Data to Custom Location 

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 Backup Explorers User Guide

Backup and Restore of SQL Server Databases

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide