Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    32

    Unanswered: Moving the ReportSever DB

    We are going to move the report services DBs to a faster SAN withinh the same SQL server machine. Which would be the best way to do it?

    I was thinking, stop SRS services, detach the ReportSever and ReportSeverTempDB, copy mdf and ldf to new location and finally reattach.

    Would that work?

    Thanks

  2. #2
    Join Date
    Mar 2009
    Location
    Australia
    Posts
    113
    According to this article from MSDN you can do exactly what you have theorised.

  3. #3
    Join Date
    Sep 2010
    Posts
    10
    Yes this is pretty straightforward, what you mentioned will do it. The only times you typically run into issues is if you are moving the actual SSRS instance, and then it's really only an encryption key reset type of thing. If you have any issues, just post back.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •