MIS Systems Thread, SIMS/SQL and Backup Exec plan in Technical; Originally Posted by zag
If you use Veeam for backups they have a really good sandbox mode that you can ...
16th December 2013, 03:02 PM #16
Yes this is on the cards for next year, just need to get by for a few months
Originally Posted by zag
13th January 2014, 08:43 AM #17
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.
14th January 2014, 05:34 AM #18
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.
14th January 2014, 09:14 AM #19
Cheers @vikpaw, you can download it from CodePlex - TidyBackups - Home - it's free and open-source, you don't need to purchase a WinRar license (not free) and you also get the preserve option, with means you keep at least a set number of backups for each database.
14th January 2014, 09:17 AM #20
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 09:18 AM.
14th January 2014, 09:27 AM #21
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.
By Olliesaurus in forum MIS Systems
Last Post: 15th November 2013, 03:42 PM
By alexsanger in forum Wireless Networks
Last Post: 12th December 2011, 02:43 PM
By Duke in forum Hardware
Last Post: 26th October 2010, 08:39 AM
By joe90bass in forum Windows
Last Post: 5th May 2010, 02:49 PM
By Halfmad in forum Windows Server 2000/2003
Last Post: 23rd March 2009, 10:38 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)