From the course: Microsoft SQL Server 2019 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Automate backups - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
Automate backups
- [Instructor] Because backups are so important, you might find it helpful to schedule their creation so that you don't need to manually create them every time. Having the backup routine run automatically requires the use of SQL Server Agent. The Agent is the component that's responsible for scheduling and running maintenance-related jobs on SQL Server instances. Unfortunately, Agent is not included in the Express edition of SQL Server. So, if you're using that edition, then you would need to investigate some third-party options if you wanted to schedule and automate your backup processes. If you're working with the Enterprise, Standard, or like me, the Developer edition, then you do have access to the Agent service. The first step is to start SQL Server Agent. You can do that in the same Configuration Manager that we saw at the beginning of the course, or right here in Management Studio, you can find in the service listed at the bottom of the Object Explorer window. Simply…
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.