SCCM 2012 R2 - Move reporting services db to another volume on same server
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:
- Stop the SITE
%Sccminstalldir%\bin\x64\0000409\preinst.exe /stopsite
- Backup Report Server encryption keys
In Report Services Configuration Manager > Encryption Keys > Backup
Choose an appropriate location
- Stop Report Services
- Detach the DB in SQL Management Studio
- Move the files to desired location
- Attach files in SQL Mgmt Studio
- Start Report Services
- 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
s