Set-ASMonitoringSqlDatabaseArchiveConfiguration

Set-ASMonitoringSqlDatabaseArchiveConfiguration

Configures a given monitoring database with an associated archive destination database. The archive destination database must be an existing, initialized monitoring database. This cmdlet ensures that the primary and archive databases both contain monitoring database artifacts, and that their versions match.

Syntax

Parameter Set: DatabaseNameAndServerName
Set-ASMonitoringSqlDatabaseArchiveConfiguration -ArchiveDatabase <String> -Database <String> [-LinkedArchiveServer <String> ] [-Server <String> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Parameters

-ArchiveDatabase<String>

Name of the destination archive database.

-ConnectionString<String>

SQL Server connection string.

-Database<String>

Name of the primary database for which to configure archiving. Optional only if ConnectionString is specified.

-LinkedArchiveServer<String>

Name of the SQL Server that hosts the destination archive database.

-Server<String>

Name of the SQL Server that hosts the primary monitoring database.

-Confirm

Prompts you for confirmation before executing the command.

-WhatIf

Describes what would happen if you executed the command without actually executing the command.

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

• None

Outputs

The output type is the type of the objects that the cmdlet emits.

• None

Examples