SQL Server Performance

Moving the ReportSever DB

Discussion in 'SQL Server 2005 Reporting Services' started by carloarango, Sep 30, 2010.

  1. carloarango New Member

    We are going to move the report services DBs to a faster SAN within 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 files to new location and finally reattach.
    Would that work?
    Thanks
    carloarango, Sep 30, 2010
    #2

  2. MohammedU New Member

    These databases can be moved like any other user dbs.
    Just detach, copy to new location and then attach, I don't think you need to stop RS but you get any db in use error check and stop if needed...
    MohammedU, Oct 13, 2010
    #3

  3. itsupport12 New Member

    Yes moving from one server location just require deletion of database from current location & then attaching them back to location where the database resides.
    Regards,
    Network Management Services
    itsupport12, Dec 7, 2010
    #4

  4. Luis Martin Moderator

    [quote user="itsupport12"]
    Yes moving from one server location just require deletion of database from current location & then attaching them back to location where the database resides.
    Regards,
    Network Management Services
    [/quote]
    Detach not deletion.
    Luis Martin, Dec 8, 2010
    #5

Share This Page