4 Replies Latest reply on Oct 10, 2008 2:36 AM by jonchill

Moving and Upgrading SQL

jonchill Oct 9, 2008 8:51 AM

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

Re: Moving and Upgrading SQL

tdanner Oct 9, 2008 8:57 AM (in response to jonchill)

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.
Like (0)

Actions
- Re: Moving and Upgrading SQL
  
  rajivbahl Oct 9, 2008 9:17 AM (in response to tdanner)
  
  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.
  
  Like (0)
  
  Actions
  - Re: Moving and Upgrading SQL
    
    njoylif Oct 9, 2008 11:43 AM (in response to rajivbahl)
    
    If I remember correctly, I had to manually create and set permissions for my SolarWindsNPM user when I moved from 2000->2005.
    FYI
    
    Like (0)
    
    Actions
    - Re: Moving and Upgrading SQL
      
      jonchill Oct 10, 2008 2:36 AM (in response to njoylif)
      
      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.
      
      Like (0)
      
      Actions

Go to original post