Backup All Databases

Is there a way to backup all database at once in SQL Server 2000 ?

Or an easy way to bakup a lot of databases.....to make a posterior restore ?

Thanks

If you have a maintainance windows you can shut the server down and copy the files to the backup location (cold backup). Otherwise you would have to use the SQL maintainance Plan wizard or code the appropiate statements on your own.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

have a look at this article, http://www.sqlservercentral.com/columnists/pluis/2574.asp, it goes through setting up a process to automate the creation of backup devices and systems for the complete database server.