How to move RDP database to another server

[Raul Iban]

I want to move the RDP SQL database to another server.
Are there any information, white papers, etc?
Please help.

[Chad Hatting]

Raul,

Did you ever figure out how to do this? I also need to move my database to a different server?

Thanks
Chad

[Ray_Liddy]

We ended up reinstalling SIM on another server because the old SIM server was coming off lease. If you look at the following link, it does go into what needs to be done. http://h10018.www1.hp.com/wwsolutions/misc/hpsim-helpfiles/hpsim_51_migratingnewsystem.pdf

[Paede]

Yes, I did it with one of our RDP Servers. I have
- installed SQL + RDP on a new Server (clean Install)
- stopped SQL and Altiris Services
- copied eXpress.mdf eXpress_log.LDF from org. to new Server
- started all Services again
and all Jobs + Servers where on the new Server.
The Options of Altiris, PXE, RDP, Client-Settings ... you have to set again, because they are not stored in the DB.

The only problem I remember where taht the "conditions" on the Jobs where lost.

hope this helps

[Chad Hatting]

My company's HP rep helped me figure this out. Here's what you have to do, it's pretty simple actually:

1. Stop all Altiris services on your RDP server.
2. Make a backup of the eXpress database.
3. Restore that backup to your new database server.
4. On your RDP server, go to, Start=>Programs=>Administrative Tools=>Data Sources (ODBC), and click on the System DSN tab. Find the entry for Altiris eXpress Database and click on Configure. Use the configuration wizard to point RDP to your new database server.
5. Restart all Altiris services on your RDP server.

[Winter.Michael]

late answer, but Chad's solution works fine :-)

thank you, saved me a lot of time.