Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Migrating a Production NS 7 server sql database 2008 to a UAT server for testing

Created: 04 Mar 2011 | 1 comment

I am in the process of setting up a training server and would like to move my production database to UAT for the training session.  I have not installed NS yet in UAT.  What I would like to do is take a backup of prodution move it and configure it in UAT so I have all the production data but not connected to production agents.  Does someone have a kb or direstions on how to do this? 

I would also like to repeat this quarterly for QA testing reasons to but I do not wnat to rebuild the application each time just update the database.  Any "How too's" on either of these topics?  thanks

I have NS 7 Servicedesk 7 sp3 (I only want to move the NS right now).

Comments 1 CommentJump to latest comment

jharings's picture

HOWTO9763

is the most complete, but a little verbose for what you want to do. Basically, you would need to stop SQL, make a copy, and move it over to the new system. You could do a brand new setup and point it to the existing database.

I've never applied a backup of one database to a completely different database, but the procedure would be easier. Just copy the .bak file over and see if you can restore it.

I would expect lots of errors, with missing file errors, dependency checks (if you're test server isn't exactly the same as your prod). Additonally the data is 'dead' meaning with no active client updates, but if that is what you are seeking to to, this should work for you.

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.