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 [IMG]http://images.devshed.com/fda/smilies/smile.gif[/IMG]
Thank you