+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Restore Capita UnitE database backup in Technical; I may need to restore our Capita Unit-E database to a backup from Monday night plus a transaction log taken ...
  1. #1

    Join Date
    Jan 2007
    Posts
    998
    Thank Post
    15
    Thanked 48 Times in 28 Posts
    Rep Power
    26

    Restore Capita UnitE database backup

    I may need to restore our Capita Unit-E database to a backup from Monday night plus a transaction log taken from a point on Tuesday afternoon, I know most people here won't have experience with Unit-E but it is a Capita product so may be similar to SIMS restore?

    My thoughts are it is just a standard Microsoft SQL 2005 database so I just kick everyone off, use SQL Management Studio to restore the backup plus relevant transaction log file then let people back in? It is the same instance etc so there should be no issues relating to security permissions etc?

    Thanks

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    771
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Hi, not heard of Unit E, but i would imagine an SQL restore should (!) be the same whatever the system.

    Firstly, i take it you've logged this with Capita, and they are going to get back to you at some point, especially since it's a FHE product that we don't discuss much here.

    N.B. Phil Neal said in a previous thread regarding Unit-E:
    Unit-E & SIMS are aimed at two different markets and have completely different code bases.
    How do you take the backups? Is there a special app'? or do you just use a maintenance plan from Management Studio?

    If there's a special app' maybe that has a restore function built-in that does something extra, otherwise, a simple restore should be okay.

    I would take another full backup before you play around with anything AND strongly advise testing on a virtual test set up which is easy enough to set up. I frequently restore my SIMs system to a virtual setup for testing out things with my latest data without risk.

    Good luck.
    Last edited by vikpaw; 24th March 2010 at 06:49 AM. Reason: rephrase last line



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 6th January 2010, 12:59 PM
  2. non Capita Personnel Database
    By User3204 in forum MIS Systems
    Replies: 27
    Last Post: 29th October 2009, 08:50 PM
  3. Restore FMS database
    By Outpost in forum MIS Systems
    Replies: 4
    Last Post: 16th June 2009, 03:21 PM
  4. Restore sims database
    By zag in forum MIS Systems
    Replies: 4
    Last Post: 8th April 2008, 11:39 AM
  5. DHCP restore database
    By timbo343 in forum Windows
    Replies: 3
    Last Post: 11th January 2008, 08:08 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
  •