+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, How do you back up SiMS? in Technical; Just wondering what everyone else does? Do you use Sims to back up to the local drive and then NTBackup ...
  1. #1
    Kyle's Avatar
    Join Date
    Jan 2006
    Posts
    969
    Thank Post
    91
    Thanked 14 Times in 13 Posts
    Rep Power
    20

    How do you back up SiMS?

    Just wondering what everyone else does? Do you use Sims to back up to the local drive and then NTBackup to backup that file to another location

    or do you use SQL to back it up?

    Would also like to know/see what scripts/batch files you use to start/create your back ups.?

  2. #2
    mullet_man's Avatar
    Join Date
    Oct 2005
    Location
    Oldham
    Posts
    726
    Thank Post
    34
    Thanked 46 Times in 45 Posts
    Rep Power
    26
    Our script creates a backup of the database at a certain time, and then that backup gets copied to a tape during the nighly backup.

    Here is our script.

    @ECHO OFF
    ECHO YOUR SQL DATABASE IS CURRENTLY BEING BACKED UP, THIS MAY TAKE SEVERAL MINUTES
    DBATTACH /AUTO /BACKUP /SERVER=servername\SIMS2005 /USER=sa /PASSWORD=password /DATABASE=SIMS

    Seems to work fine, also don't forget you need to backup your FMS database as well, mine is the same script just changed for the FMS database.

  3. #3
    mullet_man's Avatar
    Join Date
    Oct 2005
    Location
    Oldham
    Posts
    726
    Thank Post
    34
    Thanked 46 Times in 45 Posts
    Rep Power
    26
    We then run the script via a scheduled task forgot to add, just make sure you tidy your backups in System Manager in SIMS as they can eat gigs away after a few weeks.

  4. #4
    Kyle's Avatar
    Join Date
    Jan 2006
    Posts
    969
    Thank Post
    91
    Thanked 14 Times in 13 Posts
    Rep Power
    20
    Thanks for your help

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,601
    Thank Post
    640
    Thanked 1,309 Times in 1,091 Posts
    Rep Power
    337
    our local support team wrote an application that schedules the equivalent of a system manager back up every night and names it by the day of the week then zips it all up. it's called SInfo (Sims Info), but it does have its flaws.

    i also had a simpler version that was just a simple .exe that you could schedule yourself, but haven't run it since conversion to 2005 as no longer having log truncation issues.

    i could test it. it would be interesting to see if it worked outside of our school, or in fact county as i was never sure whether it attacked sims directly or via the aforementioned SInfo program.

  6. #6
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    888
    Thank Post
    68
    Thanked 84 Times in 69 Posts
    Rep Power
    31
    I do both, dbattach script to backup to the local disk, and also use the BackupExec SQL agent.

  7. #7
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,540
    Thank Post
    818
    Thanked 383 Times in 319 Posts
    Blog Entries
    12
    Rep Power
    80
    Backupexec SQL plugin here.

    Just click the server then the database to back it up.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 6
    Last Post: 9th January 2008, 06:09 PM
  2. HI again im back
    By davyboi in forum General Chat
    Replies: 5
    Last Post: 9th January 2008, 02:48 PM
  3. Were Back...
    By russdev in forum General EduGeek News/Announcements
    Replies: 13
    Last Post: 21st September 2006, 12:46 PM
  4. Oh.My.God.....They're back
    By Dos_Box in forum IT News
    Replies: 5
    Last Post: 18th April 2006, 09:33 AM
  5. I'm back !
    By Jake in forum General Chat
    Replies: 5
    Last Post: 27th February 2006, 09:38 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
  •