Automatic SQL2000 backup

Reproduced to: http://www.cnblogs.com/Arcai/archive/2009/06/24/1509847.html

First, we remotely log on to the server, first enable the "SQLSERVERAGENT" service, click Start --- program --- management tools --- Service, and enable it in the "service"

Set "SQLSERVERAGENT" service to auto start

And start the "SQLSERVERAGENT" Service

Open SQL2000 Enterprise Manager, click Start> program> Microsoft SQL Server> Enterprise Manager, right-click "Database Maintenance Plan", and start "new maintenance plan"

Select the database you want to maintain (the master is used as an example below)

Then, always follow the default option to the "specify database backup plan" box. If you need to adjust the backup time, click "change" in the dialog box to adjust the change time.

In the next step, we recommend that you select "delete files earlier than this time ", in the following dialog box, you can select "use this directory" for "directory to store backup files" and modify it to another directory.

Then, always follow the default option to "the maintenance plan is successfully created"

After confirming, you can view the newly created maintenance plan in the Enterprise Manager.

If you need to adjust the technical task in the future, you can right-click "Database Maintenance Plan 1" and change the relevant configuration parameters.

This completes the automatic database backup function of SQL2000.