Export (0) Print
Expand All
Expand Minimize

Choose Between Local and Remote Configuration Manager Site Database Servers

Updated: December 1, 2008

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

The Configuration Manager 2007 site database must be installed on a supported version of SQL Server. Either the default instance or a named instance can be used. The site database can also be installed on a named instance of a virtual SQL Server cluster instance.

noteNote
For a list of supported SQL Server versions, see Configuration Manager Supported Configurations.

The most important aspects to plan for when choosing where to install the site database are disk I/O operations and network bandwidth considerations. Installing the site database on the local primary site server computer enables constant access to site database data, but depending on the disk array configuration of the site server, it may be slowed by disk I/O operations. Conversely, installing the site database on a remote SQL Server relies on a reliable, and fast, network connection.

Once installed, the site database can be moved to another SQL Server computer by running Configuration Manager Setup and choosing the site maintenance option.

noteNote
If the Configuration Manager 2007 site database is moved off the local site server computer, it is supported to move it back to the primary site server computer at a later time.

See Also

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft