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