locked
SCCM 2012 R2 - Move database to another disk drive on the same server RRS feed

  • Question

  • Greetings,

    I am experimenting with trying to move my SCCM 2012 R2 database to another disk drive on the same virtual machine.

    OS:  Windows Server 2008 R2 SP1

    SQL:  Microsoft SQL Server 2012 - default instance

    I am trying to move the database from the default location on the C drive to the D drive.  I have been following the instructions at the following links:

    http://blogs.technet.com/b/configurationmgr/archive/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server.aspx

    http://blogs.technet.com/b/configurationmgr/archive/2010/01/28/configmgr-2007-how-to-move-the-site-database.aspx

    https://support.microsoft.com/en-us/kb/3057073

    I have been able to successfully stop all the SCCM services, disconnect the CM_<database>, copy the MDF and LDF files from the default folder on the C drive to the E drive, using multiple locations (root, Folder named after the database, even copied the default folder structure), and then attached the database back to the default instance.   I followed the instructions in the above articles for resetting flags and permissions in the database.   After the database is attached and permissions all set, I start the process to point the SCCM 2012 R2 to the correct database, and when it tries to find the database, I am receiving the error message "This Site's database can not be changed to the current SQL Server instance."   This set was set up as a stand alone site.

    I have tried restarting the server and have tried this process multiple times, (resetting using a snapshot of the VM).   Any ideas or assistance would be greatly appreciated.

    Thank you,

    Dan

    Monday, May 18, 2015 7:09 PM

Answers

  • Hi,

    You may need use SETSPN to register an SPN for the SQL virtual name (both NetBIOS/FQDN) specifying the SQL Server Service domain account.

    Check this blog

    Can't connect to SCCM console after moving SQL database


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Daniel JiSun Wednesday, May 27, 2015 9:42 AM
    • Marked as answer by Daniel JiSun Friday, May 29, 2015 7:08 AM
    Tuesday, May 19, 2015 3:02 AM

All replies

  • What does C:\ConfigMgrSetup.log tell exactly?

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

    Monday, May 18, 2015 7:55 PM
  • Hi,

    You may need use SETSPN to register an SPN for the SQL virtual name (both NetBIOS/FQDN) specifying the SQL Server Service domain account.

    Check this blog

    Can't connect to SCCM console after moving SQL database


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Daniel JiSun Wednesday, May 27, 2015 9:42 AM
    • Marked as answer by Daniel JiSun Friday, May 29, 2015 7:08 AM
    Tuesday, May 19, 2015 3:02 AM