Restoring a Table

[vinman69]

Is there an easy way to restore a table using either SQL 2000 or veritas BE 9.0?? It seems you can only restore the entire db not a single table.

 

[SQLBill]

Can't be done. There's been several other threads about this issue.

About the only work around seems to be to restore the database to another instance, then do something like a BULK INSERT from the table on the new database to the corrupt/missing/whatever table on the old database.

-SQLBill

 

[JayKusch]

What was the initial issue that is causing you to ask this question? Was the table deleted or dropped unintentionally and if so, is the TLog still in tact.

If this is the case, you can recover the table w/ a third party utility like Lumigent Log Explorer.

If this is not the case ... SQLBill is right on the money with his statment and workaround.

Thanks

J. Kusch

 

[vinman69]

Yes I inadvertantly drop the table I was inprocess of doing what SQLBill suggested when I posted this thread. Next time hopfully there won't be one, I will give your suggestion a shot. Thanks for the help!!