From the course: Microsoft SQL Server 2016 Essential Training

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Create maintenance plans to automate backups

Create maintenance plans to automate backups - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

Create maintenance plans to automate backups

“

- [Instructor] In this section, we're going to look at automating some backups. So typically we want backups to run on a regular schedule and SQL Server 2016 provides some tools for us to do exactly that. These tools are dependent on the SQL Server agent service, so we'll need to go ahead and start that service. We could get into SQL Server Configuration manager and use that to start the service, or if you already have object explorer open, we can go to the bottom, where we see the SQL Server agent, right-click on it and hit start. You'll probably receive one or more popups asking do you really want to start this service, and just click yes on all of them. And now the SQL Server agent has started, we see a green arrow next to it, that's the icon that represents the service is running. So now we can create the automated plan to run backups on a regular basis. This is done in the management section of object explorer. So open up management and in there I'll look at the maintenance…

Contents