Set-ASMonitoringSqlDatabaseArchiveConfiguration
TOC
Collapse the table of content
Expand the table of content

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.


Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

-ConnectionString<String>

SQL Server connection string.


Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

true (ByPropertyName)

Accept Wildcard Characters?

-Database<String>

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


Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

true (ByPropertyName)

Accept Wildcard Characters?

-LinkedArchiveServer<String>

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


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

-Server<String>

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


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

true (ByPropertyName)

Accept Wildcard Characters?

-Confirm

Prompts you for confirmation before executing the command.


Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-WhatIf

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


Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

<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

Show:
© 2016 Microsoft