September 2008
Beginner to intermediate
768 pages
17h 40m
English
book
Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®
by Robert D. Schneider, Darril Gibson
Content preview from Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
VIII.2.5. Automating Things with Maintenance Plans
Setting up and managing all the maintenance jobs that we've shown you in this chapter demands a significant amount of work on the administrator's part. If you've stuck with us this far, you're about to see how managing these sometimes-mundane responsibilities can be made easier with maintenance plans.
It's probably simplest to think of maintenance plans as a collection of events that helps guide SQL Server in automatically executing the administrator's maintenance requirements. Microsoft has made it easy to create and maintain maintenance plans via a collection of graphical tools and wizards. We spend some time to help you understand these helpful assistants.
For the purposes of this simple example, assume that you want to automate a series of steps that culminates in a full backup of a particular database. We show you how to use the SQL Server Maintenance Plan Wizard to make this happen, and then show you how to fine-tune the automatically generated maintenance plan.
Launch the SQL Server Management Studio.
Connect to the appropriate SQL Server instance.
Expand the connection's entry in the Object Explorer view.
Expand the Management folder.
Right-click the Maintenance Plans folder.
Choose the Maintenance Plan Wizard menu option.
This launches the SQL Server Maintenance Plan Wizard where you specify your requirements.
Give your maintenance plan a name, along with an optional description, and click Next.
You can also create separate schedules ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.