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 ...
22nd January 2008, 09:47 AM #1
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.?
IDG Tech News
22nd January 2008, 10:10 AM #2
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 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.
22nd January 2008, 10:12 AM #3
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.
22nd January 2008, 04:35 PM #4
22nd January 2008, 05:52 PM #5
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.
22nd January 2008, 06:55 PM #6
I do both, dbattach script to backup to the local disk, and also use the BackupExec SQL agent.
23rd January 2008, 10:35 AM #7
Backupexec SQL plugin here.
Just click the server then the database to back it up.
By djm968 in forum MIS Systems
Last Post: 9th January 2008, 07:09 PM
By davyboi in forum General Chat
Last Post: 9th January 2008, 03:48 PM
By russdev in forum General EduGeek News/Announcements
Last Post: 21st September 2006, 01:46 PM
By Dos_Box in forum IT News
Last Post: 18th April 2006, 10:33 AM
By Jake in forum General Chat
Last Post: 27th February 2006, 10:38 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)