Database Backup Question (Newb :0)
 

Hello... :eek:

Sorry, I'm new here and new to SQL (please dont kill me for asking)

What I'm trying to do is write a script to backup a few databases in SQL. I know that I can just right click on the db and back it up, but how is it possible to write a script to backup more than one database... for example I have two databases:

x.
-new_table00
-new_table01

y.
-table00
-table01
-table02

Total: 2 tables in the x database, 3 tables in the y database

and I want to back both of those databases up with a single script.. Can someone walk me through this (Im sure its pretty simple), or can someone post a link as to where I can find information on how to do this in Microsoft SQL Server 2000.

Also information on how to backup specific tables within the database would be nice http://images.devshed.com/fda/smilies/smile.gif

Thank you