We used to use MS SQL's built-in backup , but it basically made the file too large .
So heres an easy backup script i wrote .
Sims.net Complete Backup Script
Appends passwords , and Rars them up also .
We have them backed up onto our q nap which is attached to our Sims server as a drive/ISCSI .
If you dont have a Iscsi device and your using vmware , the easiest way would be to add a hard-disk as a raw drive to store the backups.
That's quite useful. Have you seen @matt40k 's Tidy Backups routine?
I'd be tempted to cut out the copying it all to a temp folder, especially the docstorage, and just redirect the output rar.
When you rar the backup, the source file is F:, which should be a C:
I'm not sure about creating and deleting the Temp folder. At least call it SIMSTemp just in case some other program wants to make a temp folder.
I use rar and you can save a profile that will auto delete, as well as fix the file time, do multiple files etc. Can you pass a rar'ing profile to the command line, that might save some lines too.
For 45 quid you can buy SQLBackupAndFTP which not only is a brilliant little sql server backup utility, but it can encrypt and upload to cloud storage
Last edited by zag; 14th January 2014 at 10:18 AM.
I wouldn't recommend backing up your MIS to Google Drive, Dropbox, Skydrive, Amazon S3 - encrypted or not and definitely not to a FTP server! (must at least be SFTP) Also if it goes offsite you need to have the schools governers\SLT approval so they can sign off the risk, especially if it's going outside of the UK.
There are currently 1 users browsing this thread. (0 members and 1 guests)