Create SQL Maintenance Plan in SQL Server Management Studio (SSMS)
SQL Maintenance Plan plays huge role in SQL Server. Therefore I am going to explain step by step how to create SQL Maintenance Plan. Using that you can do lots of plan simultaneously.
1st Step:
Flow below path to create SQL Maintenance Plan.
After login to SSMS go to
Management-> Maintenance Plan -> Maintenance Plan Wizard
Figure 1 shows that how to start Maintenance Plan.
Figure 1
It will popup window like Figure 2.
Figure 2
Press next.
2nd Step
After following 1st step it will be pop up window like Figure 3.
Figure 3
In here can provide Name for the Maintenance Plan, description for the Maintenance plans which going to create. It will provide to select Server. And according to that can logging using Windows Authentication or SQL Server Authentication. Press Next button and it will be pop up window like Figure 4.
Figure 4
3rd Step
It asks what the plans are. According to your requirements you can provide plans which want to create. Can be check on check box which wants to create Maintenance Plan. In here I checked some plans (Figure 4) which I want to make Maintenance Plan likewise you can select whatever plans. Click on next button.
4th Step
After following above step it will be popup new window like Figure 5. Using that window can be move up down selected plans. Click on next button.
Figure 5
Next it will be popup window like Figure 6. And using that can be provide validity to database it means that what are the data base that create Maintenance Plan belong.
5th Step
Next according to 2nd step which selected plans one by one SSMS provide window and you can provide database which you want to make plan.
Figure 6 show that According to Check Database Integrity Task.
Figure 6
Figure 7
Figure 8
Figure 9
Figure 10
Figure 11
Figure 12
Figure 13
Your Comments are highly appreciated; it will be improving my knowledge also.
1st Step:
Flow below path to create SQL Maintenance Plan.
After login to SSMS go to
Management-> Maintenance Plan -> Maintenance Plan Wizard
Figure 1 shows that how to start Maintenance Plan.
Figure 1
It will popup window like Figure 2.
Figure 2
Press next.
2nd Step
After following 1st step it will be pop up window like Figure 3.
Figure 3
In here can provide Name for the Maintenance Plan, description for the Maintenance plans which going to create. It will provide to select Server. And according to that can logging using Windows Authentication or SQL Server Authentication. Press Next button and it will be pop up window like Figure 4.
Figure 4
3rd Step
It asks what the plans are. According to your requirements you can provide plans which want to create. Can be check on check box which wants to create Maintenance Plan. In here I checked some plans (Figure 4) which I want to make Maintenance Plan likewise you can select whatever plans. Click on next button.
4th Step
After following above step it will be popup new window like Figure 5. Using that window can be move up down selected plans. Click on next button.
Figure 5
Next it will be popup window like Figure 6. And using that can be provide validity to database it means that what are the data base that create Maintenance Plan belong.
5th Step
Next according to 2nd step which selected plans one by one SSMS provide window and you can provide database which you want to make plan.
Figure 6 show that According to Check Database Integrity Task.
Figure 6
- Figure 7 show that According to Shrink Database Task.
Figure 7
- Figure 8 show that According to Rebuild Index Task.
Figure 8
- Figure 9 shows that Update Statistics Task.
Figure 9
- Figure 10 shows Cleanup History Task
Figure 10
- Figure 11 shows that how to create Backup
Figure 11
- Now all my schedule plans were finish and it will be pop up new window like Figure 12.
Figure 12
- Now you can change and create new Job schedule by pressing Change button. And it will be popup window like Figure 13.
Figure 13
- By pressing next it will be popup new window and next it will be process and create Maintenance Plan according to your requirements.
Your Comments are highly appreciated; it will be improving my knowledge also.
0 comments:
Post a Comment