Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Migrating backend SQL from 2005-64bit to 2008-R2-64bit on new cluster

Hi all,

i am hoping to do a migration to of my backend SQL from its current microsoft cluster to a brand new cluster. I will be moving SQL versions from 2005 to 2008.

what are your thoughts on what i shold do to make this seamless? i am hoping to not even have to run the DB configurastion wizzard for NPM ro NTA, i will just stop all application servicves, bring up the new cluste rinstance witht he same name, and then bring them up again and have no problems :-)

additional tasks:
- Add solarwinds username/password that current NPM uses on the current instance
- I know i have to enable CLR on the new SQL, but i can not remember if there are a bunch of other things i need to do on the SQL box to make it work

thoughts?

cheers

dan

Find more posts tagged with

Accepted answers

bshopp

Yes, for NPM it is required still. If you are installing APM or IPAM standalone, then you shouldn't need it.

All comments

netlogix

If you do all that, then I don't think you'd need anything else, but if you had problems, just re-run the config wizards. That looks like a bit of work, when you could just backup/restore the DB and run the wizard (no need to match IPs/Names).

I've moved my npm DB a few time doing it that way.

bshopp

Have you seen this doc to see if it provides additional guidance

FormerMember

thanks all for the help... i see there is no reference to enabling CLR in that document... is it still a fundamental requirement on a new DB instance for version 10*?

bshopp

Yes, for NPM it is required still. If you are installing APM or IPAM standalone, then you shouldn't need it.

FormerMember

awesome, thank you. and do you know if i need to re-run the DB wizard on every poller? or just the main poller? i have 5 additional ;ollers and an additional webserver