Open SQL Server Management Server and in the left pane, navigate to Management, Maintenance Plans
Right click in the right pane, the context menu appears.
Select Maintenance Plan Wizard. The SQL Server Maintenance Plan Wizard appears
Click Next
Enter a name and a description
Click the Change... button to define a schedule
Define a schedule which runs every day, say at 2AM. Click OK when you're finished.
Click Next.
In the list with available Maintenance Tasks, check Back Up Database (Full)
Click Next
Since there is only 1 task, we don't have to determine the order, so click Next
Select the Databases dropdown box, the following screen appears
Select System databases and click OK
As you can see, the system databases are now selected
Click on the elipsis button (...) behind the Folder textbox
Select a folder where your databases are stored and click OK.
Then click Next
A resume is shown of the to be performed actions, Click Finish to perform these actions.
The Maintenance Plan is created. You can choose to see a report of it, by clicking the Report button
Click Next
When you have checked the report, close it.
In the SQL Server Management Studio you can see that the Management Plan is created
Under the SQL Server Agent jobs you can see that a new job is created. This job actually does the backup.
Finished!
