내보내기(0) 인쇄
모두 확장

How to Move the Site Database

Topic last updated—January 2008

You can move the SQL Server site database after setup has completed to a different SQL Server computer system by starting Configuration Manager Setup from the Start menu or from the Configuration Manager installation media.

Bb680707.note(ko-kr,TechNet.10).gif참고
Configuration Manager 2007 does support moving the site database from a remote SQL Server to the local site server computer (if SQL Server 2005 SP2 is installed).

To move the site database

  1. Back up the site database on the current site database server and restore it on the new site database server computer using the SQL Server Management Studio.

    Bb680707.note(ko-kr,TechNet.10).gif참고
    Ensure that the database access permissions are the same on the new site database as they are on the original site database.

  2. Ensure the primary site server computer account has administrative privileges over the new site database server computer.

  3. Close any open Configuration Manager console connections to the site server.

  4. On the primary site server computer, use the hierarchy maintenance tool (Preinst.exe) to stop all site services with the following command: Preinst /stopsite.

  5. On the primary site server computer, click Start, click All Programs, click Microsoft System Center, click Configuration Manager 2007, and click ConfigMgr Setup, or navigate to the .\bin\i386 directory of the Configuration Manager 2007 installation media and double-click Setup.exe.

  6. Click Next on the Configuration Manager Setup Wizard Welcome page.

  7. Click Perform site maintenance or reset this site on the Configuration Manager Setup Wizard Setup Options page.

  8. Select Modify SQL Server configuration on the Configuration Manager Setup Wizard Site Maintenance page.

  9. Enter the appropriate SQL Server name and instance (if applicable) for the new site database server as well as the site database name on the Configuration Manager Setup Wizard SQL Server Configuration page.

  10. Configuration Manager Setup performs the SQL Server configuration process.

  11. Restart the primary site server computer, and verify the site is functioning normally.

참고 항목

이 정보가 도움이 되었습니까?
(1500자 남음)
의견을 주셔서 감사합니다.
Microsoft는 MSDN 웹 사이트에 대한 귀하의 의견을 이해하기 위해 온라인 설문 조사를 진행하고 있습니다. 참여하도록 선택하시면 MSDN 웹 사이트에서 나가실 때 온라인 설문 조사가 표시됩니다.

참여하시겠습니까?
표시:
© 2014 Microsoft