Resume-SqlAvailabilityDatabase

Resumes data movement on an availability database.

Syntax

Resume-SqlAvailabilityDatabase [-InputObject] <AvailabilityDatabase[]> [-Script] [-Confirm] [-WhatIf]
 [<CommonParameters>]
Resume-SqlAvailabilityDatabase [[-Path] <String[]>] [-Script] [-Confirm] [-WhatIf] [<CommonParameters>]

Description

The Resume-SqlAvailabilityDatabase cmdlet resumes data movement on an availability database. If you resume synchronization for a primary database, data movement resumes on the corresponding secondary databases. If you resume a particular secondary database, only that database is affected.

Examples

Example 1: Resume synchronization for a database

PS C:\> Resume-SqlAvailabilityDatabase -Path "SQLSERVER:\Sql\Server\Instance\AvailabilityGroups\MainAG\AvailabilityDatabases\Database16"

This command resumes data synchronization for the availability database named Database16 in the availability group named MainAG.

Example 2: Resume synchronization for all databases

PS C:\> Get-ChildItem "SQLSERVER:\Sql\Server\Instance\AvailabilityGroups\MainAG\AvailabilityDatabases" | Resume-SqlAvailabilityDatabase

This command gets all the availability databases that belong to MainAG, and then passes them to the current cmdlet by using the pipeline operator. The current cmdlet resumes synchronization for each availability database.

Example 3: Create a script to resume a database

PS C:\> Resume-SqlAvailabilityDatabase -Path "SQLSERVER:\Sql\Server\Instance\AvailabilityGroups\MainAG\AvailabilityDatabases\Database16" -Script

This command creates a Transact-SQL script that resumes database synchronization for the availability database named Database16 in the availability group named MainAG. The command does not perform this action.

Parameters

-InputObject

Specifies availability database, as an AvailabilityDatabase object, that this cmdlet resumes.

Type:AvailabilityDatabase[]
Required:True
Position:2
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
-Path

Specifies the path of an availability database that cmdlet resumes. If you do not specify this parameter, this cmdlet uses current working location.

Type:String[]
Required:False
Position:2
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Script

Indicates that this cmdlet returns a Transact-SQL script that performs the task that this cmdlet performs.

Type:SwitchParameter
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Required:False
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Required:False
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False

Inputs

Microsoft.SqlServer.Management.Smo.AvailabilityDatabase

You can pass an availability database to this cmdlet.