Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Brad’s Sure Guide to SQL Server Maintenance Plans- P3: SQL Server has a reputation as being a simple database application to install, configure, and maintain. This is a little misleading. SQL Server is a powerful relational database that can handle the needs of the largest organizations and, as such, its proper maintenance almost certainly requires the attention of an experienced DBA. | History Cleanup Task.212 Maintenance Cleanup Task.213 Back Up Database Task.217 Execute T-SQL Statement Task.219 Notify Operator Task.221 Summary.225 Chapter 18 Subplans and Precedence.226 Subplans.226 Using a Single Subplan Pros and Cons.227 Using Multiple Subplans Pros and Cons.227 Using Subplans.228 How to Use Precedence.233 Summary.240 Chapter 19 Create and Modify Maintenance Plans Using the Designer.241 Establishing Your Maintenance Goals.241 Creating Maintenance Plans the Big Picture.243 Create the New Maintenance Plan.243 Create the Subplans.245 Add the Maintenance Plan Tasks.246 Configure the Maintenance Plan Tasks.251 Set Precedence.253 Define Reporting and Logging.260 Save the Maintenance Plan.262 Test the Maintenance Plan.262 Set the Schedules.263 Run in Production and Follow Up.264 Modifying an Existing Maintenance Plan.264 Summary.268 About the Author Brad McGehee currently Director of DBA Education at Red Gate Software is a SQL Server DBA trainer and writer with over 15 years SQL Server experience and over 6 years training experience. He is an accomplished Microsoft SQL Server MVP and was the founder of the popular community site SQL-Server-Performance.Com which he operated from 2000 through 2006 writing over one million words on SQL Server topics. Brad is a frequent speaker at SQL PASS European PASS SQL Connections SQLTeach devLINK SQLBits SQL Saturdays TechFests Code Camps SQL Server user groups and other industry seminars. In 2009 Brad made 33 public presentations to a total of 1 853 attendees in six different countries. A well-respected and trusted name in SQL Server literature Brad is the author or co-author of more than 15 technical books and over 100 published articles. His most recent books include How to Become an Exceptional DBA 2nd Edition Brad s Sure Guide to SQL Server 2008 and Mastering SQL Server Profiler all of which are available in PDF format at .HTTP WWW.S.QLSERVERCENTRAL.COM BOOKS When he is not travelling to spread his knowledge .
