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 server
Expand 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.
4. Follow the wizard
