SCCM

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:

1) Stop the SITE

%Sccminstalldir%\bin\x64\0000409\preinst.exe /stopsite

stop_site_1 stop_site_2

stop_site_2

3) Backup Report Server encryption keys

In Report Services Configuration Manager > Encryption Keys > Backup

Keys_backup

Choose an appropriate location

Keys_filesave

4) Stop Report Services

Stop_Reports

Stop_Results

5) Detach the DB in SQL Management Studio

Detach

6) Move the files to desired location

Report_Files

7) Attach files in SQL Mgmt Studio

Attach

AttachFiles

ConfirmFiles

8) Start Report Services

Start_Reports

Start_Results

9) Start the SCCM Services on the Site Server

Start_Services

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

Leave a Reply