I'm looking to refine our SQL backups utilizing Full, Differential, and Log Shipping. Currently, I am only performing full backups once at night. This process is taking so long that it is running throughout most of the work day. As we would like to use our standby server for reporting, this is not ideal.
I would like to increase the speed of our backups, but at the same time make things a bit more reliable. What would be the best way to accomplish this with the above 3 methods? Full backups once weekly, differential backups once daily, and log shipping every 15-30 min?
What considerations should I be making here? (Sorry this is a bit vague, just trying to get some input)
I am using SQL Server 2005