+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, backup of SIMS,FMS SQL & Docstorage in Technical; We are currently in the process of implementing a centrally hosted SIMS & FMS system for multiple schools in our ...
  1. #1

    Join Date
    Apr 2008
    Location
    Stoke on Trent
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    backup of SIMS,FMS SQL & Docstorage

    We are currently in the process of implementing a centrally hosted SIMS & FMS system for multiple schools in our authority and i am interested of any suggestions of how others perform backups for SIMS, FMS and DOCSTORAGE data.

    we are using 2 servers, one SQL server 2005 that hosts SIMS & FMS SQL database which we are intending to use the SQL maintainence tasks to perform a FULL backup for each DB to a .bak file which then gets backed up using Legato.

    the second server is used purely for the DOCSTORAGE server - is it neccesary to stop the service and then perform a backup using the legato client and then restart the service when finished?

    what do others use and can anyone recomend a better/different way?

    Regards,
    Gavin

  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
    I use maintenance plans to make full daily backups of the DBs, and get it to use a separate folder for each db. Just make sure you only have one backup system, full is best. If you use differential or incremental another system making backups can interfere when it comes to recovery.

    For DocStorage i just copy the folder out if i want a backup else it's just part of a normal tape backup, never needed to stop the service before.

  3. #3
    John_Howarth's Avatar
    Join Date
    Aug 2008
    Location
    Atherton
    Posts
    42
    Thank Post
    9
    Thanked 5 Times in 5 Posts
    Rep Power
    13
    It may be worth contacting colleagues at Wigan Council as they centrally host SIMS for all their primary schools (and have done for years).



SHARE:
+ Post New Thread

Similar Threads

  1. Mirroring SIMS database & DOCSTORAGE
    By mattstevenson2005 in forum MIS Systems
    Replies: 10
    Last Post: 16th August 2009, 12:38 PM
  2. SIMS.Net & FMS Firewall Settings
    By Chuckster in forum MIS Systems
    Replies: 1
    Last Post: 28th July 2009, 03:33 PM
  3. Replies: 2
    Last Post: 10th December 2007, 11:30 AM
  4. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 05:50 PM
  5. Wanted: SIMS FMS & Fees Ledger Guru
    By pete in forum MIS Systems
    Replies: 0
    Last Post: 22nd May 2006, 10:05 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
  •