Jump to Navigation

banskota

Schedule daily backup for sql server 2005 datbase using sql agent

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.
1.jpg

4. Follow the wizard

My portfolio

Project :Online Remittance software
Role: Project Manager/Developer
Environment: Linux/Windows (Operating System) , PHP, SQL Server (as backend)
Description: Facilitates banks to collect money from migrant Nepalese workers on banks’ counter or to the banks’ agents and deliver to the right beneficiaries.

Subscribe to RSS - banskota


Main menu 2

by Dr. Radut.