How to Schedule SQL Server Database Backups.

This video shows you how to schedule database backups in SQL server. In this tutorial we are using SQL Server 2014 management studio.

We first ensure that the SQL Server Agent is started and then set it to automatic to insure that it starts when the computer boots.

We the create two maintenance plans:

1. To produce the database backups
2. To delete old database backups that we no longer need.