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.?
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.
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.
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.
I do both, dbattach script to backup to the local disk, and also use the BackupExec SQL agent.
Backupexec SQL plugin here.
Just click the server then the database to back it up.