Description: Maintenance plan use to configure backup in MSSQL Server. This feature is only available in MSSQL Standard and Enterprise Edition. In this example the maintenance plan with full daily backup and cleanup after 2 working copy of database.
Procedure: Please find below steps to configure backup maintenance plan in MSSQL Server
· Check SQL Agent Service is running and set automatic from services.msc. The maintenance plan is depend on this service.
· Open SQL Management studio for create maintenance plan.
· In the Object Explorer pane, expand the Management folder, right-click on Maintenance Plans, and the select Maintenance Plan Wizard.
· On the welcome page of the wizard, click next.
· Fill all details of as define in wizard
· Name: As you want to display in management studio under plan
· Schedule:Define Schedule to run this plan as defined in below image:
· In this example we have define daily backup at 5:00 AM
· On Select maintenance page filled tasks that you want to perform.
· On Select maintenance task order set order to run or perform tasks
· Define backup database fill required information as follow:
· Define maintenance plan as you want to keep 2 copy of database define in cleanup task.
· Select Report Option: If you want to save report in text file or mail it to any mail id then you can set
· Complete the wizard
· Plan wizard final output.
· You can fine maintenance plan in management status.
No comments:
Post a Comment