Scheduling a daily backup of sql server 2005 database using sql agent is very easy. By following below steps anyone can do that.
Open sql server 2005 Management Studio and connect a serverExpand the tree (left navigation) ”Management->Maintenance Plans”Right click on node Maintenance Plans and Click “Maintenance Plan Wizard” (As shown in figure below) which causes to open a wizard.
Follow the wizard
In 2nd step of the wizard, You can schedule the task as clicking the Button “Change” as shown i... (more)