Post reply

ReportServer TempDB

  • November 2, 2006 at 7:38 am

    #61004

    I was thinking about moving the log file for the ReportServer TempDB to another drive (the way my other DB's are setup Log and Dat Files are on separate HDs).

    Are there any suggestions requirements for moving it?

  • November 6, 2006 at 6:28 am

    #670021

    The procedure for moving tempdb data and/or log files is different from the procedure for user databases.  You need to use the ALTER DATABASE statement, if I remember correctly.  There are instructions for moving system databases on the Microsoft website - you should be able to find them if you do a search.

    John

  • November 7, 2006 at 6:33 am

    #670270

    Thanks John,

    I moved the tempdb some time ago and there were very specific instructions for it. However I wasn't sure if the reportserver tempdb required the same sort of instructions. I'll browse around MS's site some more. Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply