Get-CsDatabaseMirrorState

Returns information about whether database mirroring has been implemented for a specified database on a specified pool. Database mirroring enables you to simultaneously maintain two copies of a database, with each copy residing on a different server. This cmdlet was introduced in Lync Server 2013.

Syntax

Get-CsDatabaseMirrorState
   -PoolFqdn <Fqdn>
   [-DatabaseType <DatabaseNameType>]
   [-LocalStore]
   [-Report <String>]
   [<CommonParameters>]

Description

The Get-CsDatabaseMirrorState cmdlet returns information about the mirror databases configured for a pool; this includes information about the mirror databases that might (or might not) have been configured for the Front End server database, the Location Information Service database, the call detail recording and Quality of Experience databases, and so on. For each database the cmdlet will report back the synchronization status for both the primary database and the mirror database. In some cases you will see output similar to this, including the property value DatabaseInaccessibleOrMirroringNotEnabled:

DatabaseName : lcscdr

StateOnPrimary : DatabaseInaccessibleOrMirroringNotEnabled

StateOnMirror : DatabaseInaccessibleOrMirroringNotEnabled

MirroringStatusOnPrimary :

MirroringStatusOnSecondary :

That typically means that no mirror database has been assigned to the primary database (in this case, the database lcscdr, used for maintaining call detail data).

The functions carried out by the Get-CsDatabaseMirrorState cmdlet are not available in the Skype for Business Server Control Panel.

Examples

-------------------------- Example 1 --------------------------

Get-CsDatabaseMirrorState -PoolFqdn "atl-cs-001.litwareinc.com" -DatabaseType Monitoring

The command shown in Example 1 returns the state of the database mirror assigned to the monitoring database for the pool atl-cs-001.litwareinc.com.

Required Parameters

-PoolFqdn

Fully qualified domain name of the pool whose database mirroring state is being checked. For example:

-PoolFqdn "atl-cs-001.litwareinc.com"

Type:Fqdn
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:Lync Server 2013, Skype for Business Server 2015

Optional Parameters

-DatabaseType

Type of database whose mirror state is being checked.

Allowed values for Lync Server 2013 are:

  • App
  • Archiving
  • CMS
  • Monitoring
  • Provision
  • User

Allowed values for Skype for Business Server 2015 are:

  • ActiveMonitoring
  • Application
  • Archiving
  • CentralMgmt
  • Edge
  • Lyss
  • Monitoring
  • PersistentChat
  • PersistentChatCompliance
  • Provision
  • Registrar
  • SigninTelemetry
  • User
Type:DatabaseNameType
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:Lync Server 2013, Skype for Business Server 2015
-LocalStore

Retrieves the backup mirror state from the local replica of the Central Management store rather than from the Central Management store itself.

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:Lync Server 2013, Skype for Business Server 2015
-Report

Enables you to specify a file path for the log file created when the cmdlet runs. For example:

-Report "C:\Logs\DatabaseMirrorState.html"

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:Lync Server 2013, Skype for Business Server 2015

Inputs

None

Outputs

Microsoft.Rtc.Management.Deployment.DatabaseMirrorState