From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Configure backup automation - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Configure backup automation
- [Instructor] Backups and other routine maintenance tasks can be setup to run automatically. This not only takes the burden off of the administrators to remember to create the backup, it allows the backups to be run during a specific time, usually at night when the load of a server would be low. To automate the backup we'll create a maitenence plan and we can find that in the object explorer and we'll come down to the management folder and expand that open and we'll find a maitenence plan folder there. If I right-click on it and choose maitenence plan wizard I'm going to get this error message. Now if you see this, it just means that the SQL Server agent isn't started on your computer. Let's go ahead and press okay to dismiss this dialogue box. To start the agent you can either go in through the SQL Server configuration manager or right here inside of object explorer at the very bottom you'll find an entry for the SQL Sever agent. Just right-click on it and choose start. We'll get a…
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.