We currently have 1 SBS 2003 R2 Premium Server, acting as DC, Exchange and SQL Server with a Windows 2008 R2 standard server as a member server running SQL server for SAP business one. The SQL is pasrt of the SAP business one. We have a Powervault DL2100 running Symantec BackupExec 2010 R2 with 750GB available for the backups on RAID5 and a PowerVault 124T with 2 magazines of 16 LTO-4 tapes capacity in total.
The idea was to have full backups done on the DL2100 every evening so they are done within the backup window and then copied to the tape overnight for offsite storage the next morning. The data to be backuped are around 80GB (25GB images, 25GB emails, 25GB documents like pdf's, spreadsheets, word... and 5GB of SQL databases). Obviously there is the windows files and AD data to be backed up as well.
The full backup option on daily basis is the more preferable option for me because if something goes wrong directors will be breathing down my neck especially because the do not understand IT and they expect everything to be there at a click of a button.
Can you see any pitfalls in the above idea and do you have any other suggestions with regards to the rotation of tapes?
Many thanks in advance and apologies if posted in the wrong zone