സ്ത്രീകള്‍ എങ്ങിനെ വസ്ത്രം ധരിക്കണം എന്ന് പുരുഷന്‍ നിഷ്ക്കര്‍ഷിക്കുന്നത് ശരിയോ? അല്ലെങ്കില്‍ തിരിച്ചും?

Wednesday, March 07, 2012

Creating Maintenance Plans in SQL Server 2008 R2

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
image

2. You can specify a name and description for the plan and select the desired scheduling options
image
3. Select next to see the maintenance tasks that you want to perform 
image
4. Select the Maintenance tasks order 
image
5. Select the database for the backup task. 
image
5. Select the reporting option for the plan like write log to a specific location or send an email or both.
image
6. Click finish to create your plan , while the plan is being created you will get the following status dialogue
image
7. You can see the created maintenance plan in object explorer
image
when you double click the Backup Plan from above window, you can get the designer
image

Courtesy : http://sysadmindop.blogspot.in/  & http://rmssa.blogspot.com/

No comments:

Post a Comment

Hmmmmm... what are you thinking? Do not forget to comment,It helps us to improve this blog and help us to make better. on