Start-VBRSharePointItemRestoreSession

Short Description

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

Applies to

Veeam Backup & Replication

Product Edition: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License

Syntax

This cmdlet provides parameter sets that allow you to:

Start a restore session from a specific restore point of the Microsoft SharePoint database.

Start-VBRSharePointItemRestoreSession [-RestorePoint] <IVBRApplicationRestorePoint> [-StagingServerName <String>] [-StagingInstanceName <String>] [-StagingServerPort <Int32>] [-GuestCredential <PSCredential>] [-SqlCredential <PSCredential>] [-UseWindowsAuthentication][<CommonParameters>]

Start a restore session from the restore points of backed-up VMs with Microsoft SQL databases for the specified Microsoft SharePoint site collection.

Start-VBRSharePointItemRestoreSession [-SiteCollectionRestorePoint] <IVBRSiteCollection> [-StagingServerName <String>] [-StagingInstanceName <String>] [-StagingServerPort <Int32>] [-GuestCredential <PSCredential>] [-SqlCredential <PSCredential>] [-UseWindowsAuthentication] [<CommonParameters>]

Detailed Description

This cmdlet allows you to start restore sessions and recover Microsoft SharePoint databases. You can run restore sessions with the following scenarios:

Restore session of all site collections and Microsoft SharePoint databases from a specific restore point.
Restore session of backed-up VMs with Microsoft SQL databases for the specified Microsoft SharePoint site collection.

Parameters

Parameter	Description	Type	Required	Position	Accept Pipeline Input
RestorePoint	Specifies a restore point. The cmdlet will get a Microsoft SharePoint database from the specified restore point.	Accepts the IVBRApplicationRestorePoint object. To get this object, run the Get-VBRApplicationRestorePoint cmdlet.	True	0	True (ByValue)
SiteCollectionRestorePoint	Specifies restore points of backed-up VMs with Microsoft SQL databases for the specified Microsoft SharePoint site collection.	Accepts the IVBRSiteCollection object. To get this object, run the Get-VBRSiteCollectionRestorePoint cmdlet.	True	0	True (ByValue)
StagingInstanceName	Specifies a name of a Microsoft SQL instance. The cmdlet will create the content database within this instance.	String	False	Named	False
StagingServerPort	Specifies a port number. The cmdlet will use this port to connect to the staging Microsoft SQL server.	Int32	False	Named	False
GuestCredential	Specifies user account credentials to connect to the staging Microsoft SQL server. The user account must have Full control permissions.	Accepts the PSCredential object. To get this object, run the Get-Credential cmdlet.	False	Named	False
SqlCredential	Specifies credentials for authenticating to the Microsoft SQL server.	Accepts the PSCredential object. To get this object, run the Get-Credential cmdlet.	False	Named	False
UseWindowsAuthentification	Defines that the cmdlet will use Windows authentication.	SwitchParameter	False	Named	False
StagingServerName	Specifies a name of the staging SQL server. The cmdlet will mount the restore point of the VM with the SharePoint database to the specified server.	String	False	Named	False

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About CommonParameters section of Microsoft Docs.

Output Object

The cmdlet returns the VBRSharePointItemRestoreSession object that contains setting of restore sessions started to explore backed-up Microsoft SharePoint databases and to perform operations with these databases.

Examples

Start-VBRSharePointItemRestoreSession Example 1. Starting Restore Session for All Site Collections

This example shows how to start a restore session for all site collections and Microsoft SharePoint databases from a specific restore point.

$restorepoint = Get-VBRApplicationRestorePoint -SharePoint

Start-VBRSharePointItemRestoreSession -RestorePoint $restorepoint[0]

Perform the following steps:

Run the Get-VBRApplicationRestorePoint cmdlet. Provide the SharePoint parameter. Save the result to the $restorepoint variable.
Run the Start-VBRSharePointItemRestoreSession cmdlet. Set the $restorepoint variable as the RestorePoint parameter value.

Start-VBRSharePointItemRestoreSession Example 2. Starting Restore Session from Microsoft SQL Backup

This example shows how to start a restore session from a Microsoft SQL backup that contains the necessary Microsoft SharePoint database.

$restorepoint = Get-VBRApplicationRestorePoint -SQL

Start-VBRSharePointItemRestoreSession -RestorePoint $restorepoint[0]

Perform the following steps:

Run the Get-VBRApplicationRestorePoint cmdlet. Provide the SQL parameter. Save the result to the $restorepoint variable.
Run the Start-VBRSharePointItemRestoreSession cmdlet. Set the $restorepoint variable as the RestorePoint parameter value.

Start-VBRSharePointItemRestoreSession Example 3. Starting Restore Session from Specific Restore Point

This example shows how to start a restore session for all site collections and Microsoft SharePoint databases from a specific restore point. The cmdlet will use a staging server and will create the content database within the VEEAMSQL2016 instance.

$restorepoint = Get-VBRApplicationRestorePoint -SharePoint

$creds = Get-credential

Start-VBRSharePointItemRestoreSession -RestorePoint $restorepoint -StagingServerName "LOCALHOST" -StagingInstanceName "VEEAMSQL2016" -GuestCredential $creds -SqlCredential $creds -UseWindowsAuthentification

Perform the following steps:

Run the Get-VBRApplicationRestorePoint cmdlet. Provide the SharePoint parameter. Save the result to the $restorepoint variable.
Run the Get-Credential cmdlet to create a credential object that you want to use for authenticating to the staging server and an SQL instance. Save the result to the $creds variable.
Run the Start-VBRSharePointItemRestoreSession cmdlet. Specify the following settings:

Set the $restorepoint variable as the RestorePoint parameter value.
Specify the StagingServerName parameter value.
Specify the StagingInstanceName parameter value.
Set the $creds variable as the GuestCredential parameter value.
Set the $creds variable as the SqlCredential parameter value.
Provide the UseWindowsAuthentification parameter.

Start-VBRSharePointItemRestoreSession Example 4. Starting Restore Session from Microsoft SQL Databases with Microsoft SharePoint Site Collections

This example shows how to start a restore session from the restore points of backed-up VMs with Microsoft SQL databases for the SharePoint server Microsoft SharePoint site collection.

$restorepoint = Get-VBRApplicationRestorePoint -SharePoint -Name "SharePoint server"

$sitecollection = Get-VBRSiteCollection -RestorePoint $restorepoint

$sitepoint = Get-VBRSiteCollectionRestorePoint -SiteCollection $sitecollection

Start-VBRSharePointItemRestoreSession -SiteCollectionRestorePoint $sitepoint[0]

Perform the following steps:

Run the Get-VBRApplicationRestorePoint cmdlet. Provide the SharePoint parameter. Save the result to the $restorepoint variable.

Run the Get-VBRSiteCollection cmdlet. Set the $restorepoint variable as the RestorePoint parameter value. Save the result to the $sitecollection variable.

Run the Get-VBRSiteCollectionRestorePoint cmdlet. Set the $sitecollection variable as the SiteCollection parameter value. Save the result to the $sitepoint variable.

Run the Start-VBRSharePointItemRestoreSession cmdlet. Set the $sitepoint variable as the SiteCollectionRestorePoint parameter value.

Related Commands

Get-VBRApplicationRestorePoint

Get-Credential