+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, Automate Serco Facility Backup in Technical; Hi, Does anyone know if there is a way of automating/scripting a Facility backup rather than having to do it ...
  1. #1
    Divaldo's Avatar
    Join Date
    Feb 2008
    Location
    Leicestershire
    Posts
    80
    Thank Post
    25
    Thanked 4 Times in 4 Posts
    Rep Power
    14

    Automate Serco Facility Backup

    Hi,

    Does anyone know if there is a way of automating/scripting a Facility backup rather than having to do it manually through the CMIS interface?

    Is a SQL backup sufficient?

    Thanks very much.

  2. #2
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    753
    Thank Post
    173
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    48
    I have a auto-it script that runs from a scheduled task to do this, have you used auto-it before?

    RobK

  3. #3
    Divaldo's Avatar
    Join Date
    Feb 2008
    Location
    Leicestershire
    Posts
    80
    Thank Post
    25
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    Thanks,

    No i haven't used it or heard of it before. I'll take a look...

  4. #4

    mattx's Avatar
    Join Date
    Jan 2007
    Posts
    9,240
    Thank Post
    1,058
    Thanked 1,068 Times in 625 Posts
    Rep Power
    740
    Just a daily specific cmd to backup ours [ with other stuff ]

    Code:
    net use z: /d
    net use z: \\10.0.0.175\share /user:admin PASSWORD
    net stop mssqlserver
    net stop "facility eportal"
    net stop "facility data server"
    copy "E:\Program Files\Microsoft SQL Server\Data\MSSQL\Data\cmis_admin_data.mdf" \\stjohns01\e$\Dbasebkup\Serco\Thu /Y
    copy "E:\Program Files\Microsoft SQL Server\Data\MSSQL\Data\cmis_admin_log.ldf" \\stjohns01\e$\Dbasebkup\Serco\Thu /y
    copy "E:\Program Files\Microsoft SQL Server\Data\MSSQL\Data\cmis_admin_data.mdf" "z:\stjohns02\SERCO Database\thursday" /y
    copy "E:\Program Files\Microsoft SQL Server\Data\MSSQL\Data\cmis_admin_log.ldf" "z:\stjohns02\SERCO Database\thursday" /y
    copy "E:\Junior Librarian Database\Junior Librarian 3\Junior3\Data\*.mdb" "Z:\Stjohns02\Junior Librarian Database\thursday" /y
    net start "facility eportal"
    net start "facility data server"
    net start mssqlserver
    net use z: /d
    Hopefully should give you an idea.....

  5. #5

    mattx's Avatar
    Join Date
    Jan 2007
    Posts
    9,240
    Thank Post
    1,058
    Thanked 1,068 Times in 625 Posts
    Rep Power
    740
    Quote Originally Posted by robk View Post
    I have a auto-it script that runs from a scheduled task to do this, have you used auto-it before?

    RobK
    Care to share it ? May be worth changing mine.....

  6. #6
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    753
    Thank Post
    173
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    48
    No problem sharing, don't think it will attach here, so drop me a PM and I will email it back.

    RobK

  7. #7

    Join Date
    Jan 2007
    Posts
    424
    Thank Post
    7
    Thanked 32 Times in 27 Posts
    Rep Power
    21
    Generally, something like IBM Tivoli or Veritas BackupExec will do this for you..

  8. #8
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    753
    Thank Post
    173
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    48
    Generally, something like IBM Tivoli or Veritas BackupExec will do this for you..
    True, backing up the server and database should be safe, though if you run a Serco backup you can just restore them to a access database for testing/DR etc.

    I didn`t get a straight answer on SQL backup from Serco hence started playing with auto-it.

    My thoughts? Both can`t hurt!

    RobK

  9. #9

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

    Backup

    We officially recommend a Facility backup is taken manually every night.
    In theory, a SQL backup to a bk file is enough to save your bacon in an emergency.

    If you need further advice please contact support who will be able to help with this. If you need help specifically with how to set up the backup within SQL, i believe there is a document already produced. If not, perhaps i should produce one?


    Michael Sanderson
    Technical Support Engineer
    Serco Learning Solutions

  10. #10

    mattx's Avatar
    Join Date
    Jan 2007
    Posts
    9,240
    Thank Post
    1,058
    Thanked 1,068 Times in 625 Posts
    Rep Power
    740
    Quote Originally Posted by michael2k6 View Post
    We officially recommend a Facility backup is taken manually every night.
    But that is not much of a solution is it ?

    Are you looking at automating this procedure at all or possible writing something to sit along side Facility ?
    I can't see every school manually backing up their database - specially schools without the technolgy know how.
    I am not having a go, just giving a voice to schools who don't have IT Technicans or IT savy staff.

  11. #11

    Join Date
    Apr 2008
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Smile Automatic backups are almost here......

    Having spoken my RSDM from Serco, I have advised that they are close to automating facility backups

  12. #12
    Dan_ATR's Avatar
    Join Date
    Oct 2011
    Location
    Bournemouth
    Posts
    91
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Has there been any update to this since 2008?

    I have to do this manual process every day in the morning and evening for the past 3 years and its starting to do my head in.....

    The process listed in the script is not very good as it requires the stopping and starting of the services which if not good for us.

    Also I am very surprised Serco has not constructed an automated procedure for such a simple job as this.

  13. #13

    mattx's Avatar
    Join Date
    Jan 2007
    Posts
    9,240
    Thank Post
    1,058
    Thanked 1,068 Times in 625 Posts
    Rep Power
    740
    Quote Originally Posted by Dan_ATR View Post
    Has there been any update to this since 2008?

    I have to do this manual process every day in the morning and evening for the past 3 years and its starting to do my head in.....

    The process listed in the script is not very good as it requires the stopping and starting of the services which if not good for us.

    Also I am very surprised Serco has not constructed an automated procedure for such a simple job as this.
    Just set the CMD script I did as a schedule so it runs at 3am in the morning. I don't think the stopping and starting of the services is going to have that much of an effect at that time.......unless you have someone working on the database at stupid o'clock !!
    I'm so glad I'm out the education ICT world !!

  14. #14
    Dan_ATR's Avatar
    Join Date
    Oct 2011
    Location
    Bournemouth
    Posts
    91
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Unfortunately we do get users on at stupid o'clock.... Its a nightmare some times when we want downtime for even a day... >.<

    Take me with you...... lol please....

  15. #15

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

    There is no current plan to automate the backup process. This can be logged as a change request on our forums in the usual manner if you would like to persue it.

    You can schedule a SQL backup using the SQL Agent as long as you are comfortable with backup and restore of SQL databases in this way. Support would be able to offer very limited advice on this area, and we can't be held lible for this backup process working as it's not our software.

    Most of the schools I speak to do implement this though and I do know a few who have had to use it *cough* @john.

    Mic @ Serco


    The above post is my own and does not necessarily represent the views and opinion of my employer or their associates.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Serco Facility and MS SQL server Express edition
    By cheredenine in forum MIS Systems
    Replies: 19
    Last Post: 19th December 2008, 06:42 PM
  2. Fronter and Serco Facility
    By cheredenine in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 10th November 2008, 08:24 AM
  3. Quick ePortal question - Serco Facility
    By cheredenine in forum MIS Systems
    Replies: 0
    Last Post: 14th July 2008, 03:20 PM
  4. Serco Facility administration crating an MSI
    By nicholab in forum MIS Systems
    Replies: 3
    Last Post: 24th November 2007, 11:52 AM
  5. SIMS.Net vs Serco Facility
    By JoHimself in forum MIS Systems
    Replies: 17
    Last Post: 18th October 2007, 09:44 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
  •