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

Get-VESQLDatabase

Short Description

Returns Microsoft SQL databases.

Applies to

Product Edition: Community, Standard, Enterprise, Enterprise Plus

Syntax

Get-VESQLDatabase [-Session] <VESQLRestoreSession> [[-Name] <string[]>]  [<CommonParameters>]

Detailed Description

This cmdlet returns an array of Microsoft SQL databases.

Parameters

Parameter

Description

Required

Position

Accept
Pipeline
Input

Accept
Wildcard
Characters

Session

Specifies an active restore session for a Microsoft SQL database.

The cmdlet will return information about the Microsoft SQL databases from the specified restore session.

True

0

True (ByValue)

False

Name

Specifies a name of a Microsoft SQL database. The cmdlet will return information about the Microsoft SQL database with the specified name.

False

1

False

Yes

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information about common parameters, see http://go.microsoft.com/fwlink/p/?LinkID=113216.

Return Type

VESQLDatabase[]

Example 1

This example shows how to get a list of Microsoft SQL databases from the specified restore session.

  1. Run Get-VESQLRestoreSession to get a restore session for the Microsoft SQL database. Save the result to the $session variable.
  2. Run Get-VESQLDatabase with the $session variable.

PS C:\PS> $session = Get-VESQLRestoreSession

PS C:\PS> Get-VESQLDatabase -Session $session[0]

Example 2

This example shows how to get information about a Microsoft SQL database with the specified name.

  1. Run Get-VESQLRestoreSession to get a restore session. Save the result to the $session variable.
  2. Run Get-VESQLDatabase with the $session variable.

PS C:\PS> $session = Get-VESQLRestoreSession

PS C:\PS> Get-VESQLDatabase -Session $session[0] -Name "SQLDatabase"

Related Commands

Get-VESQLRestoreSession

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