Help Center
Choose product document...
Veeam Backup & Replication 9.5 Update 4
Veeam Explorers PowerShell Reference

Start-VESQLRestoreSession

Short Description

Starts restore sessions to explore backed-up Microsoft SQL databases and to perform operations with these databases.

Applies to

Product Edition: Community, Standard, Enterprise, Enterprise Plus

Syntax

Start-VESQLRestoreSession [-RestorePoint] <IVBRApplicationRestorePoint>  [<CommonParameters>]

Detailed Description

This cmdlet starts a new restore session, establishes a connection to the Veeam Backup & Replication server and retrieves Microsoft SQL databases backed up on this server. Within the restore session, you can get backed-up databases using the following cmdlets:

After you get backed-up Microsoft SQL databases, you can perform the following operations with these databases:

Parameters

Parameter

Description

Required

Position

Accept
Pipeline
Input

Accept
Wildcard
Characters

RestorePoint

Specifies a restore point to start a new restore session. You will be able to use the session to perform operations with Microsoft SQL databases that this restore point contains.

Accepts the IVBRApplicationRestorePoint object. To get this object, run the Get-VBRApplicationRestorePoint cmdlet.

True

0

True (ByValue)

False

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see Microsoft Docs.

Output Object

The cmdlet returns the VESQLRestoreSession object that contains settings to connect to Veeam Backup & Replication.

Example

This example shows how to start a restore session of a Microsoft SQL database.

  1. Run the Get-VBRApplicationRestorePoint cmdlet to get a restore point. Save the result to the $restorepoint variable.
  2. Run the Start-VESQLRestoreSession cmdlet with the $restorepoint variable.

$restorepoint = Get-VBRApplicationRestorePoint -SQL

Start-VESQLRestoreSession -RestorePoint $restorepoint[0]

Related Commands

Get-VBRApplicationRestorePoint

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