Stop-VESQLInstantRecovery

Short Description

Stops an active instant recovery session for a Microsoft SQL Server database.

Product: Veeam Backup & Replication

Product Edition: Enterprise, Enterprise Plus, Veeam Universal License

Syntax

Stop-VESQLInstantRecovery [-Database] <VESQLIRDatabase> [-Force] [<CommonParameters>]

Detailed Description

This cmdlet stops an active instant recovery session for a backed-up Microsoft SQL Server.

Parameters

Parameters
Parameter	Description	Type	Required	Position	Accept Pipeline Input
Database	Specifies a Microsoft SQL Server database. The cmdlet will stop the instant recovery session of this database. Accepts the `VESQLIRDatabase` object. To get this object, run the `Get-VESQLIRDatabase` cmdlet.	`VESQLIRDatabase`	True	0	True (ByValue)
Force	Defines that the cmdlet will show no prompt before executing the command.	`SwitchParameter`	False	Named	False

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About Common Parameters section of Microsoft Learn.

Examples

Stopping Instant Recovery Session of a Microsoft SQL Server Database

This example shows how to stop an instant recovery session of the monthly_db database.

$IRDatabase = Get-VESQLIRDatabase -DatabaseName "monthly_db"

Stop-VESQLInstantRecovery -Database $IRDatabase

Perform the following steps:

Run the Get-VESQLIRDatabase cmdlet. Specify the DatabaseName parameter value. Save the result to the $IRDatabase variable.
Run the Stop-VESQLInstantRecovery cmdlet. Set the $IRDatabase variable as the Database parameter value.

Get-VESQLIRDatabase