+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
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 ...
  1. #16

    Join Date
    Feb 2007
    Location
    Kent
    Posts
    633
    Thank Post
    266
    Thanked 51 Times in 43 Posts
    Rep Power
    40
    Quote Originally Posted by zag View Post
    If you use Veeam for backups they have a really good sandbox mode that you can use to test your backup strategies.

    Although saying that, their VM backup is so good I've never needed it

    The days of having to individually restore Sims data files or server OS's are long gone with Veeam! Thats the real power of snapshots and virtualization.
    Yes this is on the cards for next year, just need to get by for a few months

  2. #17

    Join Date
    Dec 2009
    Posts
    603
    Thank Post
    8
    Thanked 36 Times in 34 Posts
    Rep Power
    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.

  3. #18

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    That's quite useful. Have you seen @matt40k 's Tidy Backups routine?
    Some thoughts:
    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.

  4. #19

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    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.

  5. #20
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,738
    Thank Post
    894
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85
    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.

  6. #21

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    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.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [SIMS] SIMS SQL Databases and Maintenance Plans
    By Olliesaurus in forum MIS Systems
    Replies: 12
    Last Post: 15th November 2013, 03:42 PM
  2. Backups, QNAP and Backup Exec
    By alexsanger in forum Wireless Networks
    Replies: 1
    Last Post: 12th December 2011, 02:43 PM
  3. Oracle S7000 and Backup Exec 2010
    By Duke in forum Hardware
    Replies: 3
    Last Post: 26th October 2010, 08:39 AM
  4. Windows 2008, SQL 2008 and Backup Exec 12
    By joe90bass in forum Windows
    Replies: 2
    Last Post: 5th May 2010, 02:49 PM
  5. Server 2003 and backup exec 12
    By Halfmad in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 23rd March 2009, 10:38 PM

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
  •