Thwack » SolarWinds » Orion Network Performance Monitor » Moving and Upgrading SQL

in More Search Options

Moving and Upgrading SQL

Last post 10-10-2008 2:36 AM by jonchill. 4 replies.
Page 1 of 1 (5 items)
Sort Posts:

  • 10-09-2008 8:51 AM

    • jonchill
    • Top 10 Contributor
      •
    • Joined on 08-13-2003
    • United Kingdom
    • Posts 589
    • Points 2,397

    Moving and Upgrading SQL

    Reply

    I've got a new server with SQL 2005 Standard installed and want to move our NPM and NCM DB's from there exisitng SQL 2000 server to this new box, is it just a case of moving the DB's and then re-running the configurator for NPM and NCM?

    Would doing the move as part of the upgrade to NPM v9.1 cause any issues?

    Any help would be much appreciated.

     Thanks

     
    • Post Points: 3

  • 10-09-2008 8:57 AM In reply to

    • tdanner
    • Top 10 Contributor
      •
    • Joined on 06-19-2007
    • Posts 557
    • Points 1,417
    • SolarWinds Employee

    Re: Moving and Upgrading SQL

    Reply

    I wouldn't expect any issues from that. Moving the databases, doing the upgrade, then specifying the new db server when the 9.1 config wizard asks should work fine.

    Tim Danner
    SolarWinds Development Team
    • Post Points: 3

  • 10-09-2008 9:17 AM In reply to

    • rajivbahl
    • Top 100 Contributor
      •
    • Joined on 05-15-2008
    • India
    • Posts 74
    • Points 375

    Re: Moving and Upgrading SQL

    Reply

    Just make sure your DB Server is on RAID 1+0 for its best performance.

    Till the time you have a good and latest database backup copy you should not have any issues.

    Rajiv Bahl
    NPM SLX 9.1
    HS Poller
    Additional Poller 1 SLX
    • Post Points: 3

  • 10-09-2008 11:43 AM In reply to

    • njoylif
    • Top 50 Contributor
      •
    • Joined on 07-03-2007
    • Atlanta, GA
    • Posts 202
    • Points 422

    Re: Moving and Upgrading SQL

    Reply

     If I remember correctly, I had to manually create and set permissions for my SolarWindsNPM user when I moved from 2000->2005.

    FYI

    Larry J. Rice
    RelayHealth
    Network Architect
    678-984-1686
    • Post Points: 3

  • 10-10-2008 2:36 AM In reply to

    • jonchill
    • Top 10 Contributor
      •
    • Joined on 08-13-2003
    • United Kingdom
    • Posts 589
    • Points 2,397

    Re: Moving and Upgrading SQL

    Reply

     I moved the DB fine and tested under v9, which worked fine. Then upgraded to 9.1 and everything worked.

     Thanks to everyone for there input.

    • Post Points: 1
Page 1 of 1 (5 items)