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 ...
24th March 2010, 12:20 AM #1
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?
IDG Tech News
24th March 2010, 06:38 AM #2
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:
How do you take the backups? Is there a special app'? or do you just use a maintenance plan from Management Studio?
Unit-E & SIMS are aimed at two different markets and have completely different code bases.
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.
Last edited by vikpaw; 24th March 2010 at 06:49 AM.
Reason: rephrase last line
By Grommit in forum Windows
Last Post: 6th January 2010, 12:59 PM
By User3204 in forum MIS Systems
Last Post: 29th October 2009, 08:50 PM
By Outpost in forum MIS Systems
Last Post: 16th June 2009, 03:21 PM
By zag in forum MIS Systems
Last Post: 8th April 2008, 11:39 AM
By timbo343 in forum Windows
Last Post: 11th January 2008, 08:08 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)