SQL Server 2008 R2 Backup Best Practices
Posted on 2014-03-12
I am looking for everyones opinions on this topic, currently we are using Symance Backup Exec 12 with SQL Agents to back up our databases. We do a disk to disk to tape topology using Full Backups. When restoring we can only restore from tape which is not the best solution.
In the past I have ran maintenance plans and backed up actual SQL backups that way along with using a SQL agent. What does everyone reccomend for backup performance and ease of restore.
Should both be implented? Would it be over kill?