This chapter is going to serve as the culmination of Chapter 1 (on full backups), Chapter 2 (on differential backups), and Chapter 3 (on transaction log backups). We will first get into the creation of a sustainable maintenance plan to manage our backups all together in one main area using a set schedule, as opposed to manually running backups or having full, differential, or transaction log backups running at different times, and then we will run that plan and review.
Setting Up the Maintenance Plan
In order to automate the backups, we need to have SQL Server ...
