Simple task today. I want to relocate my SQL Reporting Services DB to another drive/volume on the same server.
Overview steps:
Stop the SCCM Site
Stop Report Services
Detach and move files
Attach files in new location
Start Report Services
Start SCCM Services
Done
Detailed steps:
1) Stop the SITE
%Sccminstalldir%\bin\x64\0000409\preinst.exe /stopsite
3) Backup Report Server encryption keys
In Report Services Configuration Manager > Encryption Keys > Backup
Choose an appropriate location
4) Stop Report Services
5) Detach the DB in SQL Management Studio
6) Move the files to desired location
7) Attach files in SQL Mgmt Studio
8) Start Report Services
9) Start the SCCM Services on the Site Server
Let SCCM manage the rest of the services
You have now successfully relocated the location of the Report Services DB files.
Done…
Note: If you’re looking to relocate the entire SQL Instance, this looks like a good resource: http://smsimpossible.blogspot.com.au/2012/09/how-to-move-databases-for-sccm-2012.html