backup of all the database in server eg:node 1 in sql server 2000

hi

can any one let me know how to take backup of all the database in server

once .

thanxs

prabhu-bangalore

Create a maintenance plan, and then execute the SQL Agent job it creates. You can remove the plan afterwards if this is a once off operation.

In SQL enterprise manager, go to Management, Database Maintenance Plans. Choose the All Databases option, and then click through to the Specify the Database Backup Plan option.

After this go to SQL Server Agent, Jobs and find the newly created job for the maintenance plan. Right click it and start job.

Hope this helps.