Backuping up multiple databases at once

I'm going through the docs and I can't find a way to backup multiple databases at once, rather than them individually. I see you can create a backup device, but you have to select every individual database. I know in 2000 you could do it ....

Are you referring to using a maintanence plan or t-sql? I assume a maintanence plan?

Regardless, you can't backup multiple db's in a single backup operation...what you can do is create multiple backup statements, one for each database (which is what would happen in SQL 2000 if you chose multiple db's from the GUI), then each database will be backed up serially (i.e. one after the other), and would look like this in t-sql:

backup db1 to disk....

backup db2 to disk....

backup db3 to disk....

If you'd like to backup multiple db's in parallel, you could take each of your t-sql backup commands and run them across seperate connections, or create seperate scheduled jobs for each...

I don't have the 2005 GUI on this computer, so I can't validate/verify the selection of multiple db's from it, but I would be surprised if you can't do it from the Maintanence Plan...seems odd...I'll check later and get back to you if nobody else responds before I get to it...

HTH,

|||

Thanks Chad

That works out just fine.. i can do it individually . I thought I was missing an obvious setting or something . I'm not that experienced with 2005 and I wasn't sure.

I appreciate the response.

|||

Backup task UI of Maintenace plan provides selection of multiple databases.

Gops Dwarak