
February 14th, 2007, 08:36 AM
|
|
Registered User
|
|
Join Date: Feb 2007
Posts: 1
Time spent in forums: 10 m 46 sec
Reputation Power: 0
|
|
|
(Dont kill the newb) Database Backup Question
Hello...
Sorry, I'm new here and new to SQL ( I tried using the search function, but I couldn't find what I was looking for... 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
Thanks for all of your help!!
|