[This is preliminary documentation and is subject to change. Blank topics are included as placeholders.]

Installs one or more Microsoft Communications Server 2010 databases.

Syntax

Install-CsDatabase -LocalDatabases <SwitchParameter> [-Clean <SwitchParameter>] [-Confirm [<SwitchParameter>]] [-DatabasePaths <String[]>] [-Force <SwitchParameter>] [-ForDefaultInstance <SwitchParameter>] [-ForInstance <String>] [-GlobalCatalog <Fqdn>] [-GlobalSettingsDomainController <Fqdn>] [-Report <String>] [-SkipPrepareCheck <SwitchParameter>] [-Update <SwitchParameter>] [-UseDefaultSqlPaths <SwitchParameter>] [-WhatIf [<SwitchParameter>]]
Install-CsDatabase -CentralManagementDatabase <SwitchParameter> -SqlServerFqdn <Fqdn> [-Clean <SwitchParameter>] [-Collocated <SwitchParameter>] [-Confirm [<SwitchParameter>]] [-DatabasePaths <String[]>] [-Force <SwitchParameter>] [-GlobalCatalog <Fqdn>] [-GlobalSettingsDomainController <Fqdn>] [-Report <String>] [-SkipPrepareCheck <SwitchParameter>] [-SqlInstanceName <String>] [-Update <SwitchParameter>] [-UseDefaultSqlPaths <SwitchParameter>] [-WhatIf [<SwitchParameter>]]
Install-CsDatabase -ConfiguredDatabases <SwitchParameter> -SqlServerFqdn <Fqdn> [-Clean <SwitchParameter>] [-Confirm [<SwitchParameter>]] [-DatabasePaths <String[]>] [-ExcludeCollocatedStores <SwitchParameter>] [-Force <SwitchParameter>] [-ForDefaultInstance <SwitchParameter>] [-ForInstance <String>] [-GlobalCatalog <Fqdn>] [-GlobalSettingsDomainController <Fqdn>] [-Report <String>] [-SkipPrepareCheck <SwitchParameter>] [-Update <SwitchParameter>] [-UseDefaultSqlPaths <SwitchParameter>] [-WhatIf [<SwitchParameter>]]
Install-CsDatabase -DatabaseType <Application | Archiving | Monitoring | User | Provision> -SqlServerFqdn <Fqdn> [-Clean <SwitchParameter>] [-Collocated <SwitchParameter>] [-Confirm [<SwitchParameter>]] [-DatabasePaths <String[]>] [-Force <SwitchParameter>] [-GlobalCatalog <Fqdn>] [-GlobalSettingsDomainController <Fqdn>] [-Report <String>] [-SkipPrepareCheck <SwitchParameter>] [-SqlInstanceName <String>] [-Update <SwitchParameter>] [-UseDefaultSqlPaths <SwitchParameter>] [-WhatIf [<SwitchParameter>]]

Parameters

Parameter Required Type Description

Service

Optional

Xds Identity

Enables you to specify a particular database to be installed; for example: -Service MonitoringDatabase:atl-cs-001.litwareinc.com.

PoolFqdn

Optional

String

Fully qualified domain name of the pool where the database is to be installed (for example: -PoolFqdn atl-sql-001.litwareinc.com). If you use the –PoolFqdn parameter Install-CsDatabase will read the Communications Server topology and automatically install all the databases that need to be installed on that pool

CentralMgmtStore

Optional

Switch Parameter

If this parameter is included, Install-CsDatabase will install the Central Management database on the computer specified using the –SqlServer parameter.

LocalHost

Optional

Switch Parameter

If this parameter is included, Install-CsDatabase will read in the Communications Server topology and install databases and stores as needed on the local computer. You cannot use both –LocalHost and –SqlServer in the same command.

SqlServer

Optional

String

Fully qualified domain name of the computer where the Central Management database is to be installed. For example: -SqlServer atl-sql-001.litwareinc.com. This

InstanceName

Optional

String

Name of the database instance where the database is to be installed. A database instance is simply a set of running processes that provides access to database files.

DatabasePaths

Optional

String

Specifies the drives and folders where data and log files can be stored; for example: -DatabasePaths "D:\Logs", "E:\Data". If not included, SQL Server will select the drives and folders to be used as storage locations.

Clean

Optional

Switch Parameter

If this parameter is included, Install-CsDatabase will delete and reinstall databases as needed. If this parameter is not included, Install-CsDatabase will not overwrite any existing databases.

SkipPrepareCheck

Optional

Switch Parameter

When present, causes Install-CsDatabase to forego its initial preparation checks.

ExcludeCollocatedStores

Optional

Switch Parameter

When present, suppresses a warning message telling you that any collocated database stores must be installed on the local computer.

Update

Optional

Switch Parameter

When present, updates the existing database.

GlobalCatalog

Optional

String

Full qualified domain name of a global catalog server. For example: atl-dc-001.litwareinc.com.

GlobalSettingsDomainController

Optional

String

Full qualified domain name of a domain controller. For example: atl-dc-001.litwareinc.com.

Force

Optional

Switch Parameter

When present, forces the installation of the new database even if an existing database of that type is currently in use.

Report

Optional

String

Enables you to specify a file path for the log file created when the cmdlet runs. For example: -Report "C:\Logs\Certificates.xml"

UseDefaultSqlPath

Optional

Switch Parameter

WhatIf

Optional

Switch Parameter

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

Confirm

Optional

Switch Parameter

Prompts you for confirmation before executing the command.

Detailed Description

Microsoft Communications Server 2010 makes extensive use of SQL Server databases: configuration information is stored in the Central Management database; archiving data is stored in the Archiving database; etc. As a general rule, these databases are set up at the same time you install Communications Server or at the same time you install a Communications Server role (such as Monitoring Server) that requires a database backed.

On rare occasions, however, you might need to manually install a Communications Server database; this could be because you need to move a database to another server, or because a setup-related problem failed to install the database for you. If such a need should arise, the Install-CsDatabase cmdlet provides a way for you to install any of the SQL Server databases used by Microsoft Communications Server.

Return Types

Install-CsDatabase does not return any values or objects.

Examples

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

Copy Code
Install-CSDatabase -CentralMgmtStore -SqlServer atl-sql-001.litwareinc.com -InstanceName rtc -DatabasePaths "G:\CSDB"

The command shown in Example 1 installs the Central Management database on the server (or SQL cluster) atl-sql-001.litwareinc.com. The database will be installed in the rtc instance, and will make use of the folder G:\CSDB.

-------------------------- Example 2 ------------------------

Copy Code
Install-CsDatabase -PoolFqdn atl-sql-001.litwareinc.com -DatabasePaths "E:\CSLog", "F:\CSLog", "G:\CSDB"

In Example 2, Install-CsDatabase reads in the Communications Server 2010 topology and then installs any required databases on the pool atl-sql-001.litwareinc.com