May 19, 2016 at 6:55 am
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
May 20, 2016 at 1:53 am
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.
May 23, 2016 at 9:26 am
Thanks for the testing! I did not see your post until this morning. I presume you did not need to stop reporting services?
May 24, 2016 at 3:37 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy