Restore RM CC4 Database Backup

[kai91]

Does anyone know how to restore the database backup files off a RM CC4 server? Thanks

[Michael]

Best advice would be to contact RM themselves, seeing as you're using an RM network.

[kai91]

Best advice would be to contact RM themselves, seeing as you're using an RM network.

I dont have a rm support contract so they are not interested in helping me.

[matt40k]

You should still have access to RM site, we would need to know the backup solution, the backup software, the database type and a few other things.

[kai91]

You should still have access to RM site, we would need to know the backup solution, the backup software, the database type and a few other things.

The backup type is a .backup file. The database type as far as i can gather is a postgreSQL database and the backup was created using the database backup task in RM CC4 which i managed to retrieve from the D:/rmetwork/rmmanage/rmdatabases/backup folder. Thanks for your help.

[PiqueABoo]

It definitely is postgreSQL. I don't know, but I'd expect the backup to have been made via pg_dump, and it can be restored via pg_restore. Whether there are things you should do before/after restoring is anyone's guess e.g. I assume you'd need RM service that talk to the DB stopped etc., and if it's an old backup then you might get discontinuity between that and user and computer objects in AD.

Why do you want to do this?

[Paul_Warner]

A few quick questions,

1. Is Comms and Security Installed and is Service Host working.
2. Why do you want to restore the DB ??
3. How old is the backup of the DB when was it made.

I have a CC4 Network and CC4 is hugely reliant on the DB and make one small little change and BOOM bye bye CC4. I may be able to give you advice but be very careful and do it at your own risk .... Also could you not restore the server from a backup tape if it is bad.

[kai91]

A few quick questions,

1. Is Comms and Security Installed and is Service Host working.
2. Why do you want to restore the DB ??
3. How old is the backup of the DB when was it made.

I have a CC4 Network and CC4 is hugely reliant on the DB and make one small little change and BOOM bye bye CC4. I may be able to give you advice but be very careful and do it at your own risk .... Also could you not restore the server from a backup tape if it is bad.

Comms and Security is installed and working, service host is installed and wont start due to the lack of the database i am trying to restore.
I have virtualised my cc4 server but the only part i cant copy across is the Database
The database backup was taken the same time as the image of the server was taken so there should be no difference in that

[kai91]

Can anyone help me? Thanks

[bossman]

I presume you have the Physical server to which you P2V'd?

If so then it should be fairly easy to export the database from the physical server and import it into the VM server through the PostgreSQL database Voila!

If you have PostgresSQL installed on the VM server that is, you should be able to find the version on your Physical server and install it on your VM server.

All you require is the PostgresSQL username and password

P.S. Question? Why have you Virtualised your CC4 DC anyway?
I would have done all the other servers but not the DC, I would have kept this a physical box but then that is my opinion