Moving ReportServerTempDB files to new drive, do I need to stop Reporting Services?

• trhorner

  Ten Centuries

  Points: 1075

  More actions

  May 19, 2016 at 6:55 am

  #310776

  I want to move the ReportServerTempDB data and log files to another drive to free up space on the drive they are currently located on. Other than the basic steps (see below) that one uses for these types of moves, is there anything "special" about ReportServerTempDB I need to do? Specifically, stopping report services? That seems prudent - anything else? Thanks in advance!

  Here are the basic steps I will use (I have done this before with other database files):

  ALTER DATABASE ReportServerTempDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

  ALTER DATABASE ReportServerTempDB SET OFFLINE;

  -- Physically move the files to a new location.

  ALTER DATABASE ReportServerTempDB

  MODIFY FILE ( NAME = ReportServerTempDB,

  FILENAME = 'H:\data\ReportServerTempDB.mdf');

  ALTER DATABASE ReportServerTempDB

  MODIFY FILE ( NAME = ReportServerTempDB_log,

  FILENAME = 'H:\log\ReportServerTempDB_log.ldf');

  ALTER DATABASE ReportServerTempDB SET ONLINE;

  ALTER DATABASE ReportServerTempDB SET MULTI_USER

• BLOB EATER

  SSChampion

  Points: 14609

  More actions

  May 20, 2016 at 1:53 am

  #1880435

  I have tested your steps on my dev box. It works, to be honest in the past I just did a deattach / reattach, but like I said your code is fine.

  I just queried sysfiles to confirm the new correct location.

• trhorner

  Ten Centuries

  Points: 1075

  More actions

  May 23, 2016 at 9:26 am

  #1880811

  Thanks for the testing! I did not see your post until this morning. I presume you did not need to stop reporting services?

• BLOB EATER

  SSChampion

  Points: 14609

  More actions

  May 24, 2016 at 3:37 am

  #1880984

  trhorner (5/23/2016)

  ---

  Thanks for the testing! I did not see your post until this morning. I presume you did not need to stop reporting services?

  Didn't touch it.

  thanks