Friday, March 9, 2012

Moving ReportServer and ReportServerTempDB to a different drive.

I need to move these databases from the C to the E driver on the existing server. I found instructions on how to move to a different server but I could not find specific instructions on moving these databases on what I need to dor. Has anyone been successfully in moving these databases to a different drive? If so, I would be grateful in you sharing your knowledge.

Thanks.

While these databases contain metadata for SSRS, they are not particularly special otherwise, just detach/re-attach them as you would any other database :)

If you're unclear on how to attach/detach, take a look at the sp_attach_db and sp_detach_db sprocs in books online (FYI, SSRS will need to be shut down while you do this or you won't be able to detach in the first place since it will have open connections)

Hope this helps!

|||I am familiar with the attach and detach stored procedures, so I will try this out on one of our virtual servers. Thanks a lot.

No comments:

Post a Comment