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 - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.