Database Maintenance Plan (scheduling data base backup)

Database Maintenance Plan (Full AX & CRM Backup)

Below document shows how to create an automatic backup plan

Step 1 : Open the SQL management Studio and connect to the database server and as per the below screen create an Maintenance Plan

Step 2: SQL Maintenance plan Wizard is opened and give next

 Step 3: Specify the name for the job, and make sure after the completion of giving proper name, no white spaces allowed 

Step 5: On above screenshot there is a column named as Schedule in that click on the change button

                In which you can Schedule timing when backup need to be occurred

Step 6: After Creating the Schedule, as mention in the below screen give Next

Step 7: Next check the Backup check box and give Next

Step 8: Whatever Checkbox you have selected will be mentioned, as you can see in the below Screen and then give Next

Step 9: After choosing the full database backup, select the required database and click ok

Step 10: In Destination column, choose the path in where the backup need to be stored as you can see in below screen

 Step 11: After creating the path give next, in this step you can choose where the Log file need to be stored.

Note: Log files will show the statement of the backup plan job

Step 12: Finish the job plan