We have a 3TB database, and current backup schedule is - Weekly Full Backup, Daily Diff and hourly transaction log from maintenance plans. All these backups are performed using Backup command and compression options. The size of these backups are almost 500GB.

Is this a good approach (huge compressed backups)? Can i consider striped backups? And what are the benefits and drawbacks? Would striped backup help in reducing backup time? And does they benefit restore/backup operations? Maintenance plan design tool is having an option for striped backup? Should i create a different script for striped backups?

Please advise.

Browse other questions tagged or ask your own question.