+ Post New Thread
Results 1 to 10 of 10
Windows Server 2000/2003 Thread, Restore RM CC4 Database Backup in Technical; Does anyone know how to restore the database backup files off a RM CC4 server? Thanks...
  1. #1

    Join Date
    Aug 2011
    Location
    Lincolnshire
    Posts
    88
    Thank Post
    10
    Thanked 2 Times in 1 Post
    Rep Power
    21

    Restore RM CC4 Database Backup

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

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340
    Best advice would be to contact RM themselves, seeing as you're using an RM network.

  3. #3

    Join Date
    Aug 2011
    Location
    Lincolnshire
    Posts
    88
    Thank Post
    10
    Thanked 2 Times in 1 Post
    Rep Power
    21
    Quote Originally Posted by Michael View Post
    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.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,384
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    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.

  5. #5

    Join Date
    Aug 2011
    Location
    Lincolnshire
    Posts
    88
    Thank Post
    10
    Thanked 2 Times in 1 Post
    Rep Power
    21
    Quote Originally Posted by matt40k View Post
    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.

  6. #6

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    115
    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?

  7. #7

    Join Date
    Sep 2011
    Location
    In the Live@Edu Clouds
    Posts
    30
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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.

  8. #8

    Join Date
    Aug 2011
    Location
    Lincolnshire
    Posts
    88
    Thank Post
    10
    Thanked 2 Times in 1 Post
    Rep Power
    21
    Quote Originally Posted by Paul_Warner View Post
    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

  9. #9

    Join Date
    Aug 2011
    Location
    Lincolnshire
    Posts
    88
    Thank Post
    10
    Thanked 2 Times in 1 Post
    Rep Power
    21
    Can anyone help me? Thanks

  10. #10

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,905
    Thank Post
    1,186
    Thanked 1,057 Times in 749 Posts
    Rep Power
    328
    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
    Last edited by bossman; 11th February 2012 at 03:01 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. Autodesk Inventor 2009 Professional - RM CC4
    By pauldsimpson in forum Educational Software
    Replies: 5
    Last Post: 27th September 2010, 01:33 PM
  2. Restore Capita UnitE database backup
    By googlemad in forum MIS Systems
    Replies: 1
    Last Post: 24th March 2010, 05:38 AM
  3. RM CC4 & Compensation
    By mburland in forum Network and Classroom Management
    Replies: 26
    Last Post: 20th September 2009, 10:50 PM
  4. Replies: 7
    Last Post: 12th February 2009, 12:53 PM
  5. SIMS .Net upgrade - database backup problems
    By WithoutMotive in forum MIS Systems
    Replies: 7
    Last Post: 28th February 2006, 02:43 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •