+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, BACKING UP CMIS in Technical; Hi Looking through the old comments, no-one seems to have asked recently whether CMIS can be automatically backed up. The ...
  1. #1

    Join Date
    Mar 2012
    Location
    Stratford Upon Avon
    Posts
    6
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    BACKING UP CMIS

    Hi

    Looking through the old comments, no-one seems to have asked recently whether CMIS can be automatically backed up. The IT Department back up the server, but have told me that CMIS still needs backing up from within the system daily. This is getting to be a pain so any help in automating this would be appreciated!

    Thanks

    K

  2. #2
    eddyc's Avatar
    Join Date
    Aug 2008
    Location
    Bristol
    Posts
    429
    Thank Post
    95
    Thanked 47 Times in 43 Posts
    Rep Power
    21
    Unless things have changed since we left CMIS, it is possible to write a script to robocopy the .mdb file every night to a share and then create a folder with the date that the file was copied. As the share gets full, delete the oldest 5 / archive them off to an external drive and retain in the school safe.

    If its now SQL driven, then things are much easier.

  3. #3


    Join Date
    May 2009
    Posts
    2,487
    Thank Post
    198
    Thanked 629 Times in 481 Posts
    Rep Power
    227
    What exactly do they mean "back up the server". You can set backups as a job on SQL server. We take a full backup of the database daily and incremental every few hours during the day. If you are doing that, you shouldn't need to use the CMIS backup feature.

  4. #4

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    585
    Thank Post
    83
    Thanked 112 Times in 91 Posts
    Rep Power
    57
    Facility has been SQL driven for the last 8 years atleast. Certainly in the UK.

    The server is probably backed up overnight and hopefully there's a SQL agent backing up the MDF and LDF too. Failing that, you can set backup jobs in SQL, and then cold copy the bak file as part of the server backup. What most people would do there is set a backup for each day in a fortnight or month, and set to overwrite rather than append.
    That way, you get say 14 files, the oldest is 13 days old, and the 14th is the newest. You'll take up 14 times the size of the database, though as there's no compression by default.

    The reason that you're told to still backup the database from within the software is because should you ring Advanced Learning support, they'll not be able to assist with restoring your server / SQL backups, as they won't know where they are, how they've been done, etc. If you give them a bdb backup, they can always get your data back from that backup.

    However, consider what you're backing up. If you have a backup of all datasets somewhere, and that is backed up to tape or disk (whatever method the rest of the network uses), then each day you backup you only need to backup the templates and the current dataset. If you're not fussed about the activity log either, then check the 'do not include audit trail' box when performing the backup and it will help keep the size down.

    That way, in the even of a catastrophe, you will have all the old datasets in one bdb file and your latest dataset in another, and your templates in another. Make sure if you ever need them to follow the correct restore procedure to do it in the right order.

    There is no way to schedule an automatic backup by BDB (to automate the process of backing up within the software).

  5. #5
    tli
    tli is offline

    Join Date
    Mar 2010
    Location
    Birmingham
    Posts
    14
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    9
    SQL backups are essential for dealing with major disasters but bdb backups from Facility itself are more flexible when minor things go wrong.

    For instance, if something happens during an assessment round, you can restore individual tables which means that you can roll back the assessment side without losing data from other areas such as attendance or behaviour.

  6. #6

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    585
    Thank Post
    83
    Thanked 112 Times in 91 Posts
    Rep Power
    57
    ^ what tli said.

SHARE:
+ Post New Thread

Similar Threads

  1. Backing up MSDE (WMSDE for WSS) database with BackupExec
    By meastaugh1 in forum How do you do....it?
    Replies: 13
    Last Post: 23rd July 2006, 01:56 PM
  2. back up web server
    By beeswax in forum How do you do....it?
    Replies: 6
    Last Post: 12th June 2006, 09:03 AM
  3. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 09:36 PM
  4. Replies: 11
    Last Post: 26th May 2006, 10:01 AM
  5. Mac software for backing up DVDs
    By dagza in forum Mac
    Replies: 14
    Last Post: 23rd May 2006, 11:29 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •