SQL Server 2000 database automatic backup Setup method _mssql

1. Open MS SQL Server Enterprise Manager, SQL Server Group-management-database maintenance plan

-Right-click the new maintenance plan as shown below:

Next: Select the database you want to back up

Next:

Continue to the next step:

Next: Click Change to modify data backup time

Next:

Next:

Next:

Next:

In Enterprise Manager, locate the Admin –sql Server Agent, if it does not start, red box instead of green triangle, right-click and select Start.

Tip: In SQL Server Service Manager – Service selection SQL Server Agent startup, on the "Autostart service when starting OS" check, when the system restarts, the SQL Server Agent starts automatically.