+ Post New Thread
Results 1 to 7 of 7
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 ...
  1. #1
    Hedghog's Avatar
    Join Date
    Jul 2006
    Location
    North Wales
    Posts
    194
    Thank Post
    35
    Thanked 17 Times in 16 Posts
    Rep Power
    37

    SIMS backups

    Hi All,

    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

  2. #2
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    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.

  3. #3
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    281
    Thank Post
    30
    Thanked 66 Times in 39 Posts
    Rep Power
    20
    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

  4. #4


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,394
    Thank Post
    1,417
    Thanked 872 Times in 560 Posts
    Rep Power
    643
    Our LEA wrote a nice little script for us. Backs it up to encrypted Zip files.

  5. #5

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    211
    Thank Post
    7
    Thanked 50 Times in 45 Posts
    Rep Power
    27
    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.

  6. #6

    Join Date
    Apr 2010
    Posts
    2,036
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    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.

  7. #7
    Hedghog's Avatar
    Join Date
    Jul 2006
    Location
    North Wales
    Posts
    194
    Thank Post
    35
    Thanked 17 Times in 16 Posts
    Rep Power
    37
    Hi
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS: Backup and Recovery
    By Gongalong in forum MIS Systems
    Replies: 6
    Last Post: 30th June 2012, 09:41 AM
  2. [SIMS] Sims Backup
    By squeeky in forum MIS Systems
    Replies: 45
    Last Post: 28th June 2012, 01:33 PM
  3. [SIMS] SIMS Backup - the latest
    By msi in forum MIS Systems
    Replies: 8
    Last Post: 7th January 2012, 10:03 PM
  4. [SIMS] Who's using TidyBackups to managed the SIMS backups?
    By matt40k in forum MIS Systems
    Replies: 10
    Last Post: 22nd March 2011, 11:20 AM
  5. [SIMS] Sims backup regimes
    By creese in forum MIS Systems
    Replies: 6
    Last Post: 13th September 2010, 09:52 AM

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
  •