sql management studio 2008 r2 express automatic backup

The reason behind to drag and drop the green arrow is, to develop a link between both task. Just drag that green arrow and drop it at the head of “Maintenance Cleanup Task” as shown below. Once you select it, it will show a green arrow in the bottom. Once you drag and drop the “Maintenance Cleanup Task” in the design window of the maintenance screen on the right hand side, you need to select the backup up task.

Now you need to select “Maintenance Cleanup Task” from the toolbar available in the left hand and drag and drop it on the right hand design window as shown below. Once you select modify, SQL Server Management Studio (SSMS) will take you to the design screen of the maintenance plan. However if you did not do it there, you can modify the same maintenance plan and do it.įirst of all you need to select the same Maintenance plan that you have created in the earlier article and right click on it, in order to modify it, as shown below. It would be the best, if you select the “Maintenance Cleanup Task” in Step 6 in the Pre-requisite article. Let me explain the solution step by step : In this case, you delete the backup manually or automatically ? I prefer automatically. The problem is, once automatic backup would be scheduled, it will start piling up the back up in the storage and soon, you will be out of space.

I received very good feedback about this post. Earlier, I have written an article about how to take a backup automatically in place of manual backup.

Sql management studio 2008 r2 express automatic backup