Orlando Colamatteo (3/28/2015)

---

PS regarding your question about best practices I was not sure if you meant tools or strategy so focused on toos in my last post since you mentioned Maintenance Plans (MPs). The tools you use (MPs, Ola's scripts, something else) to invoke the database backups is not nearly as important (relatively unimportant actually) as your backup and recovery strategy. The frequency with which you take a full database backup, differential database backups (if at all) and transaction log backups (if in full or bulk logged recovery) will be dictated by the data owners (usually a business owner) so your DR plan's RPO needs to line up with their expectations. That is the important thing to nail down when taking over these new instances. Do not assume that the previous schedules were correct, ask, and implement accordingly.