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.
|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.
|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.|
For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.