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

  1. Backup Report Server encryption keys

In Report Services Configuration Manager > Encryption Keys > Backup

Keys_backup

Choose an appropriate location

Keys_filesave

  1. Stop Report Services

Stop_Reports

Stop_Results

  1. Detach the DB in SQL Management Studio

Detach

  1. Move the files to desired location

Report_Files

  1. Attach files in SQL Mgmt Studio

Attach

AttachFiles

ConfirmFiles

  1. Start Report Services

Start_Reports

Start_Results

  1. 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

Daniel Apps

Hi, I'm Daniel Apps — AI platform enthusiast, unapologetic infrastructure nerd, and dad to two small humans. I write about infrastructure, AI industry topics, and the real-world chaos of modern IT.

More about me →

s