Get-VESQLPublishedDatabase - Veeam Explorers PowerShell Reference

Get-VESQLPublishedDatabase [-Session] <VESQLRestoreSession> [[-Name] <String[]>] [-ServerName <String[]>] [-InstanceName <String[]>] [<CommonParameters>]

Parameter	Description	Type	Required	Position	Accept Pipeline Input
Session	Specifies a restore session. The cmdlet will return information about a Microsoft SQL database added to the specified restore session.	Accepts the VESQLRestoreSession object. To get this object, run the Get-VESQLRestoreSession cmdlet.	True	0	True (ByValue)
Name	Specifies an array of names for Microsoft SQL databases. The cmdlet will return information about databases with the specified names.	String[]	False	1	False
ServerName	Specifies an array of target server names (as DNS names or IP addresses). The cmdlet will get Microsoft SQL databases that are published to these servers.	String[]	False	Named	False
InstanceName	Specifies an array of target instance names. The cmdlet will get Microsoft SQL databases that are published to these instances.	String[]	False	Named	False

This example shows how to get an array of all published Microsoft SQL Server databases within a restore session.

$session = Get-VESQLRestoreSession

Get-VESQLPublishedDatabase -Session $session[0]

Perform the following steps:

Run the Get-VESQLRestoreSession cmdlet. Save the result to the $session variable.

The cmdlet will return an array of restore sessions. Note the ordinal number of the necessary restore session. In our example, it is the first restore session in the array.

Run the Get-VESQLPublishedDatabase cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session.

This example shows how to get an array of published Microsoft SQL Server databases with specific names belonging to specific instances on the backup file.

$session = Get-VESQLRestoreSession

$dbnames = @("db1", "db2")

$instancenames = @("instance_01", "instance_02")

$database = Get-VESQLPublishedDatabase -Session $session[0] -Name $dbnames -InstanceName $instancenames

Perform the following steps:

Run the Get-VESQLRestoreSession cmdlet. Save the result to the $session variable.

The cmdlet will return an array of restore sessions. Note the ordinal number of the necessary restore session. In our example, it is the first restore session in the array.

Declare the $dbnames variable. Assign to this variable an array with the names of the necessary Microsoft SQL Server databases.
Declare the $instancenames variable. Assign to this variable an array with the names of the Microsoft SQL Server instances that you want to query.
Run the Get-VESQLPublishedDatabase cmdlet. Specify the following settings:

Set the $session variable as the Session parameter value and select the necessary restore session.
Set the $dbnames variable as the Name parameter value.
Set the $instancenames variable as the InstanceName parameter value.

Save the result to the $database variable to be able to use it with other cmdlets.

This example shows how to get an array of all Microsoft SQL Server databases published on the specified servers.

$session = Get-VESQLRestoreSession

$servernames = @("dlsql01", "dlsql02")

$database = Get-VESQLPublishedDatabase -Session $session[0] -ServerName $servernames

Perform the following steps:

Run the Get-VESQLRestoreSession cmdlet. Save the result to the $session variable.

The cmdlet will return an array of restore sessions. Note the ordinal number of the necessary restore session. In our example, it is the first restore session in the array.

Declare the $servernames variable. Assign to this variable an array with the names of the necessary servers with Microsoft SQL Server.
Run the Get-VESQLPublishedDatabase cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session. Set the $servernames variable as the ServerName parameter value. Save the result to the $database variable to be able to use it with other cmdlets.