Ok, I made a amateur mistake. I setup our new NPM and NCM a week ago. I thought I would use the latest and greatest. I saw you supported SQL 2008 R2 so I setup everything on that on a local install. Everything runs fine but now we want to move to our Primary SQL server its running SQL 2008 no R2. We are having issues migrating the NPM and NCM databases. Any ideas on how I could accomplish this?
Any thoughts would be greatly appreciated!
Can you check with your database guy to see if it is possible to downgrade from SQL2008R2 to SQL2008?If this is supported then you should go through the Chapter 21 in OrionAdminGuide to migrate or detach the database.