Move SCCM database to another drive

Lets try to move our SCCM database to another drive.

Always make sure you have a good backup and a rollback plan if something goes wrong

And make sure you have system administrator permission.

First start an administrative command prompt and stop all SCCM services.

You can use the command preinst.exe /STOPSITE from your SCCM installation.

Mine is located in the following path:

"C:\Program Files\Microsoft Configuration Manager\bin\X64\00000409\preinst.exe" (the last folder is dependent upon the language of the product, 00000409 is for the English version).

Next start SQL Management Studio.

If you select properties on the current SCCM database you will be able to find the current file location:

Select Files to find the current Path:

Now Detach the database:

Select Drop Connections and hit OK.

The database will disappear from the Databases folder.

Copy or move the SCCM database files to the new location:

Attach the database again:

Click Add:

Select the MDF file you copied (in the new location) and click OK:

Click OK again:

Select the database you just attached and click New Query:

Run the command:

ALTER DATABASE <ConfigMgr DB> SET TRUSTWORTHY ON

Change owner to sa:

EXEC sp_changedbowner 'sa'

Ensure that Isolation Level is set to read committed snapshot by running the command:

DBCC USEROPTIONS

If it is set to anything else than read committed snapshot then run the following commands, if isolation level is read committed snapshot then ignore next step.

ALTER DATABASE <ConfigMgr DB> SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE <ConfigMgr DB> SET READ_COMMITTED_SNAPSHOT ON

Note: You might have to switch the SQL DB to Single User mode before running the two commands. Once done, change it back to Multi User mode.

Finally start SCCM Services using Service Manager or restart the server.

After moving the System Center 2012 Configuration Manager SQL Site Database to another drive, creating a new Software Update package or a new application fails