cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 13

Moving and Upgrading SQL

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

0 Kudos
4 Replies
Level 19

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.

0 Kudos

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.

0 Kudos

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

FYI

0 Kudos

 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.

0 Kudos