+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Automated CMIS Backup in Technical; Hi Ive been asked by our IT team to see if there is an automatic way to backup CMIS on ...
  1. #1
    mark80's Avatar
    Join Date
    May 2007
    Location
    Derbyshire
    Posts
    213
    Thank Post
    24
    Thanked 11 Times in 9 Posts
    Rep Power
    16

    Automated CMIS Backup

    Hi

    Ive been asked by our IT team to see if there is an automatic way to backup CMIS on a daily basis?

    they are currently using the Data >> Backup option but doing it manually everyday and its taking up ~400mb each time they backup 8O

    The SQL Server that CMIS runs on is backed up daily to along with the file servers etc...

    So 2 questions

    1) Is there any need to backup via CMIS if the SQL server is backed up everynight

    2) Is there an automated way to backup via CMIS?

    Mark

  2. #2

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    50
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Automated CMIS Backup

    No, if the sql server is fully backed up then there isnt a need to backup cmis individually every day. It would be a good idea to back-up this way before upgrades etc...

  3. #3
    mark80's Avatar
    Join Date
    May 2007
    Location
    Derbyshire
    Posts
    213
    Thank Post
    24
    Thanked 11 Times in 9 Posts
    Rep Power
    16

    Re: Automated CMIS Backup

    cheers m8 i will let them know

    im going to owe you a few drinks

  4. #4
    budgester's Avatar
    Join Date
    Jan 2006
    Location
    Enfield, Middlesex
    Posts
    486
    Thank Post
    4
    Thanked 37 Times in 30 Posts
    Rep Power
    24

    Re: Automated CMIS Backup

    Could be done with an AutiIT script

  5. #5

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Automated CMIS Backup

    Quote Originally Posted by AndyCope
    No, if the sql server is fully backed up then there isnt a need to backup cmis individually every day.
    Isn't there an equivalent of SIMS's Docgument Server or does everything reside in the SQL database?

    @budgester
    AutoIt might be overkill if no GUI interaction is needed. If it's question of starting a scheduled task then a batch script might be enough.

  6. #6
    mark80's Avatar
    Join Date
    May 2007
    Location
    Derbyshire
    Posts
    213
    Thank Post
    24
    Thanked 11 Times in 9 Posts
    Rep Power
    16

    Re: Automated CMIS Backup

    @Networkgeezer - im not 100% sure but i think you may be right but im not sure where the folder/document structure resides?

    anyone?

  7. #7

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    50
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Automated CMIS Backup

    If you are using document storage within cmis, the folders used are designated in Database¦Document Storage¦Settings..

  8. #8
    DreddMetal's Avatar
    Join Date
    May 2007
    Posts
    91
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    15

    Re: Automated CMIS Backup

    I believe the only databases that need backing up on the SQL server in order to do a full restore are the actual CMIS database and the Master database too, without the master database you'll have no end of problems trying to restore the data.

  9. #9

    Join Date
    May 2007
    Location
    London, UK
    Posts
    22
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Automated CMIS Backup

    Even though I do auto SQL backups - I still generally do a CMIS backup once a week or before any updates/year end etc. It's quicker to be able to restore one data set etc when you screw year end up again!!. I asked Serco for auto CMIS backups over two years ago - I guess it went the same way as the new reporting system.

  10. #10
    linuxgirlie's Avatar
    Join Date
    Jul 2005
    Location
    Kent
    Posts
    340
    Thank Post
    106
    Thanked 33 Times in 18 Posts
    Rep Power
    31
    Sorry to drag up an old thread but is this still the case? I was told by Serco that I couldn't backup the data just from the sql database because it won't restore it correctly, but using the 'database' --> 'backup' is driving me crazy when all other servers are doing it automatically.

    Thanks,


    Jo

  11. #11

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    625
    Thank Post
    96
    Thanked 130 Times in 101 Posts
    Rep Power
    67
    Hi All,

    It is best practice to backup from within CMIS. The reason being, whatever happens to your servers or your database, if you can provide us (Serco) with 2 bdb files (one for templates and one for data) we can get you your data back very quickly. If you were to give us a SQL backup, it may take longer and would require much more specialist support, and might end up someone in the technical team restoring it to a new database, to create the bdb's we'd ask for in the first place. If this is the case, there might be a consultancy charge. In terms of disaster recovery, the quickest, safest and easiest way is to use the dbd files from within CMIS. This is because it backs up the raw data and so can be restored to a new database.
    If the database is backed up from the SQL server itself and you are confident that should the server die (worst case scenario) you would be able to recover that to a new server, then there is no need to backup from within Admin every day.
    Top and bottom of it is, if you can give us two bdb files, we can give you your data back. If you give us a disk with a SQL backup on, we cannot garuntee anything and might charge for the recovery and it will certainly take longer. If you know you can backup other than using bdb's and restore it yourself, that's fine, but it's your risk.

    In terms of the automated backup situaion, i believe the product manager is currently looking at automated backups and maintenance processes such as the audittrail. I'm affraid to confirm this, you'd have to contact the support desk directly.

    Michael Sanderson
    Technical Team
    Serco Learning

SHARE:
+ Post New Thread

Similar Threads

  1. MySQL automated backup
    By contink in forum *nix
    Replies: 6
    Last Post: 4th January 2008, 09:35 PM
  2. Automated PC Naming
    By Mr_M_Cox in forum Windows
    Replies: 8
    Last Post: 31st May 2007, 06:40 PM
  3. Automated Mac Address Retrieval
    By Kained in forum How do you do....it?
    Replies: 12
    Last Post: 27th March 2007, 03:25 PM
  4. Automated build testing
    By ITWombat in forum Windows
    Replies: 0
    Last Post: 20th January 2007, 11:54 PM
  5. Automated Printer Server Migration
    By Dos_Box in forum How do you do....it?
    Replies: 1
    Last Post: 5th September 2005, 08:10 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
  •