I did not think so either, but thought I would throw it out. Currently, I'm
restoring to a new db name, then copying what's needed.

-----Original Message-----
From: John Thomas [mailto:[Email Address Removed]
Sent: July 28, 2003 2:21 PM
To: LazyDBA.com Discussion
Subject: RE: Restore single tables from bak

I don't think you can do this using SQL 2000. You will have to restore the
db first.

John

-----Original Message-----
From: aaron [mailto:[Email Address Removed] Monday, July 28, 2003 11:20 AM
To: LazyDBA.com Discussion
Subject: Restore single tables from bak

How can I restore 1 or 2 tables from a .bak ?


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page