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 ...
4th September 2009, 11:23 AM #1
- Rep Power
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?
15th September 2009, 11:45 AM #2
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.
18th September 2009, 01:37 AM #3
- Rep Power
It may be worth contacting colleagues at Wigan Council as they centrally host SIMS for all their primary schools (and have done for years).
By mattstevenson2005 in forum MIS Systems
Last Post: 16th August 2009, 12:38 PM
By Chuckster in forum MIS Systems
Last Post: 28th July 2009, 03:33 PM
By projector1 in forum MIS Systems
Last Post: 10th December 2007, 11:30 AM
By thom in forum MIS Systems
Last Post: 30th August 2007, 05:50 PM
By pete in forum MIS Systems
Last Post: 22nd May 2006, 10:05 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)