MIS Systems Thread, SIMS backups in Technical; Hi All,
I need to know the steps involved in backing up our SIMS/FMS database. I would ask capita but ...
14th March 2013, 04:03 PM #1
I need to know the steps involved in backing up our SIMS/FMS database. I would ask capita but the LEA hold the licence so they won't talk to me.
The reason I am asking is our SIMS server is hanging by a thread and I need the confidence that we can rebuild SIMS if it fails (I know the LEA are supposed to do this but a school close by has just lost everything)
We are running server 2008 R2.
Any help/instructions would be very much appreciated
14th March 2013, 04:09 PM #2
We use a program called SQLBackupandFTP
Works great and automatically uploads the entire DB to a folder, separate server or Google drive account. It runs as a service so you can schedule it nightly or however you want.
Best £40 I've ever spent
We backup the DocStorage folder seperately. Thats all you need to get it up and running again assuming you know your 'sa' admin credentials.
Last edited by zag; 14th March 2013 at 04:19 PM.
14th March 2013, 04:34 PM #3
If your looking at just creating the backup files for the SIMS and FMS you can use dbAttach that comes with SIMS.
Once a backup is done it will appear in your backup folder. MSSQL10.(whatever your sims instance is)\mssql\backup
14th March 2013, 04:37 PM #4
Our LEA wrote a nice little script for us. Backs it up to encrypted Zip files.
14th March 2013, 04:38 PM #5
You ideally need to back up:
The sims folder (the one with the Setups, SNova,Star etc folders in it). (The SNOVA folder is important as it may have all your timetable files in it !).
The document server store, (usually called DOCSTORAGE)
The SIMS and FMS database files, usually sims.mdf and fms.mdf
The associated log files, sims.ldf and fms.ldf
The ldf and mdf for Discover if you use it.
You can get software that will back up the running SQL databases (we have used the Backup Exec client for doing this in the past) but now we have a script which makes a copy of the database files three time a day and the latest one (done around 4.30pm) is moved to a backup store overnight. The other stuff we just backup using the standard Backup Exec remote client overnight.
Capita provide a utility, dbattach, to allow you to restore a database onto a clean server fairly painlessly. It is documented on SupportNet: I think its default location is in the MSSQL/Binn in the same file tree as your database files can be found.
Last edited by Linfit; 14th March 2013 at 04:39 PM.
14th March 2013, 07:06 PM #6
Depending on the version of SQL you have it might have everything you need built in that can backup the databases for you. Look in the start menu on the sql server for sql management, or something like that. If you have this you can get it to do all kind of wizzy things like backing up the databases. If you have this, post back and I will give you step by step help.
15th March 2013, 03:21 PM #7
Thanks to everyone who replied. Unfortunatly it appears that The LEA have barred any but themselves from doing SIMS backups so I have left it with them to ensure we have an uptodate backup.
By Gongalong in forum MIS Systems
Last Post: 30th June 2012, 09:41 AM
By squeeky in forum MIS Systems
Last Post: 28th June 2012, 01:33 PM
By msi in forum MIS Systems
Last Post: 7th January 2012, 10:03 PM
By matt40k in forum MIS Systems
Last Post: 22nd March 2011, 11:20 AM
By creese in forum MIS Systems
Last Post: 13th September 2010, 09:52 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)