locked
System Center 2012 database RRS feed

  • Question

  • Hi,

    I have sccm2012 setup and working very well. In My setup having 1 primary standalone site and two secondary sites have configured. While setup i have configured SCCM in d drive but while installation of SQL its moved to C drive. Now c drive of My server is almost full and cannot do anything. What is the best practice to move SQL database from C drive to D drive ? Is there any chance of Site server crash ? what precautions to be taken ? what is the best link where i can get the step by step information to complete this database movement from C drive to D drive ?.

    Please suggest.

    Thanks in Advance..

    Thursday, May 21, 2015 8:05 AM

Answers

  • Make sure that there is a valid backup and just move the database from C: to D:.

    Torsten Meringer | http://www.mssccmfaq.de

    • Marked as answer by ap57 Thursday, May 28, 2015 8:50 PM
    Thursday, May 21, 2015 8:34 AM
  • High level: stop ConfigMgr services, detach database, copy files to destination, re-attach them. Start ConfigMgr services. 

    Torsten Meringer | http://www.mssccmfaq.de

    • Proposed as answer by William Bracken Thursday, May 21, 2015 1:45 PM
    • Marked as answer by ap57 Thursday, May 28, 2015 8:50 PM
    Thursday, May 21, 2015 1:38 PM

All replies

  • Make sure that there is a valid backup and just move the database from C: to D:.

    Torsten Meringer | http://www.mssccmfaq.de

    • Marked as answer by ap57 Thursday, May 28, 2015 8:50 PM
    Thursday, May 21, 2015 8:34 AM
  • Thats it ?. no site maintenance required from SCCM part ? plz suggest.. 
    Thursday, May 21, 2015 9:00 AM
  • Hi,

    As you only move them within the same SQL Server there is no need to change anything in the SCCM Site.

    Regards,
    Jörgen


    -- My System Center blog ccmexec.com -- Twitter @ccmexec

    Thursday, May 21, 2015 11:11 AM
  • Thanks Jorgen.. One more question. Do i have to re install MS SQL in D drive or just copy and past data base from C drive to D drive. Please suggest. 
    Thursday, May 21, 2015 12:59 PM
  • High level: stop ConfigMgr services, detach database, copy files to destination, re-attach them. Start ConfigMgr services. 

    Torsten Meringer | http://www.mssccmfaq.de

    • Proposed as answer by William Bracken Thursday, May 21, 2015 1:45 PM
    • Marked as answer by ap57 Thursday, May 28, 2015 8:50 PM
    Thursday, May 21, 2015 1:38 PM
  • Guys, Thank you i m done with the database movement and everything is working fine..

    Thursday, May 28, 2015 8:50 PM