Production System and Test System Sync
The company that I work for currently has a production altiris system that is running version 6.0 SP5. We have a test altiris system that is also running version 6.0 sp5 but the database structure is slightly different on our test system than on our production system. I think this is due to the fact that other altiris modules were installed on our test system. What would be the best thing to do to mirror our production server on our test server. Would it be easier to start over and re-set up altiris on the test server cleanly and restore our production database to our test system? Or would we be able to do a full database back up on our production server and restore it onto our test server even though the database structure on our test system is different?
Thanks in advance for the help,
Steve
Production System and Test System Sync
The set up for our test server is also different from our production server. The hardware is a little newer and we have a couple of additional solutions. But we've found that as long as most of our tables match (content specificially) we are able to predict likely behavior between both servers. So, it could depend on what you want to commonly test.
We frequently test future changes to the production server by making the modifications to our test server. For that, we need the values of our tables to be similar. For example, Queues, Quick Incidents, Rules, Notifications....etc. We do have mirrored drives and once we tried to overwrite our production database to our test db...but it was a mess. After having our DBA spend hours trying to rename things...we had the closest environment we'd ever had and it didn't really provide a lot of benefits.
The simpliest thing is to keep the to systems aligned with your configurations so that what can be predicted on the production server can be verified on the test. :)
May also depend on solutions
I'd also recommend matching your test server to your production server. Of utmost importance is making sure you have the same versions, not just the same solutions. Database changes can often be pretty big depending on version differences.
I'd also be curious about which databases you're mirroring. The helpdesk solution does have it's own database (Altiris_Incidents) that I've been able to float from Production over to my test server even though the test server had other solutions that the Production helpdesk box didn't have.
All in all if it's just a test I'd say backup the test database, drop the production one on top of it as a test. If it doesn't work just drop the backup back on your test box and plan on reloading it to match production. If it does work you've saved some time by not reloading the server.
- Matt
Use virtualization...
What I do, use BESR (Backup Exec System Recovery).
When I want to be sure my test = production, I make a Recovery Point of my production for use in VmWare
As long as both machine do not "see" each other there is no harm.
I test what ever I want. I can use VmWare snapshots to return to a certain point, etc, etc.
Works like a charm. Can also be done with free tools of VmWare, but... ->
One very nice addition using BESR, doing this I also have a nice Disaster recovery as I can also go from VmWare towards a physical machine with BESR. So I have setup a proces making Recovery Points every day.
One other official thing, licenses. Using this as your procedure will bring little hassle on licenses as when you have two similar systems running al the time... At least that is my point of view.
Regards
There is a KB article in the
There is a KB article in the altiris knowledge base that gives step by step instructions to mirror your production site. You will need to disable any email inboxes that you are currently using in production.
Which KB-number do you
Which KB-number do you advice?
Would you like to reply?
Login or Register to post your comment.