Backup of databases is one of most essential things for maximum uptime of your critical applications.It helps in fast recovery in case of disasters.Here are steps to take backup of Your MS SQL Server 2000 database.

Open Enterprise Manager.

Go to your database in tree and connect.

Right click the database and go to All Tasks and Click on Backup Database...

Select Database-complete radio button under Backup.

Add destination (Select the file name to use for backup operation).

In Overwrite option Select Overwrite Existing Media if you want to overwrite the existing file.

If you are taking one time backup then click ok.If you want to schedule it click on schedule check box.

You can edit schedule by clicking on change button in edit schedule window.

If you scheduled your backup then a job will be created under Management->SQL Server Agent->Jobs.