Step by Step Guide to Create Maintenance Plans in SQL Server 2008 R2

Add This To Del.icio.us Share on Facebook StumbleUpon This Add to Technorati Digg This Pin It

One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in sql server 2008 R2. You can use the following steps to create a maintenance plan 1. Select the Maintenance Plan Wizard from the context menu as shown below 2. You can specify a name and description for the plan and select the desired scheduling options 3. Select next to see the maintenance tasks that you want to perform 4. Select the Maintenance tasks order 5. Select the database for the backup task. 5. Select the reporting option for the plan like write log to a specific location or send an email or both. 6. Click finish to create your plan , while the plan is being created you will get the following status dialogue 7. You can see the created maintenance plan in object explorer when you double click the Backup Plan from above window, you can get the designer Courtesy : http://sysadmindop.blogspot.in/ Share and Care

For Latest Updates Always Visit http://satish24k.blogspot.com/

PrintPDF

For Further Reading,

POSTAL TECHNOLOGY, SAPOST, TECHNOLOGY TIPS

• Speed up Internet Connection In Windows
• Microsoft Solution: SQL Server 2000 installation fails with "...previous program installation..." error message
• More than 100 Keyboard Shortcuts
• Latest software from Software Development Centre, Chennai
• Latest DB Analyzer for Sanchaya Post dtd 12/08/2013
• Weblink -9 Useful Tool
• Download Inspector Software Setup
• Changing of Server Authentication Mode in SQL Server 2008 R2
• PAYMENT BANK LICENSE TO DOP
• Project Arrow Web Portal
• DBAnalyzer for Sanchay Post 02-04-2013
• Step by Step Guide to Create Maintenance Plans in SQL Server 2008 R2
• Guidelines to make new computerized office functional
• SQL Server Database Consistency Check Options