Post reply

Restore a SQL 2000 Database Table Only

  • August 30, 2005 at 2:43 pm

    #168578

    Hello,

    Is there a way to restore only a specific SQL 2000 table from a backup? I have a full Bkup that ran over the weekend and I have some incr that ran Sun and Mon. The user does not want the entire DB restored, just 1 table.

    Do I have to restore the DB somewhere else first and DTS the table or is there an easier way to do this?

    Thanks again!

    Ronnie

  • August 30, 2005 at 2:45 pm

    #586293

    You'll have to restore the db somewhere else and DTS the table.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • August 30, 2005 at 2:48 pm

    #586297

    Thanks. I thought so but just wanted to see if there was an easier way to do it.

    Ronnie

  • August 30, 2005 at 11:41 pm

    #586351

    With Lumigent Log Explorer you can restore a single table.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • August 31, 2005 at 8:05 am

    #586476

    I've used Lumigent to restore tables, but if your DB is manageable, and you have space and a good backup, it easier to just do a restore & DTS.

  • August 31, 2005 at 9:42 am

    #586535

    You may also want to try out SQL-Backtrack for SQL Server (produc of BMC Software).

    http://www.bmc.com

    This tool is a very advanced tool specially designed for backup/recovery of SQL databases. One feature called Logical Extraction can be used to extract any object from full database backups.

    --Kishore

     

  • August 31, 2005 at 12:38 pm

    #586604

    Thanks guys. I'll look into some of your suggestions. I ended up creating a new DB and restoring from backup to that DB. I copied the table that way. Maybe it was the long way of doing things but that's all I knew at the time.

    But I will look at some of the suggestions for future reference.

    thanks to everyone for your help!!

    Ronnie

  • August 31, 2005 at 1:17 pm

    #586625

    Also, if you know in advance, you can create the table in its own filegroup, then do a filegroup restore when needed.

    SQL LiteSpeed can do a table restore of any table in the backup. I haven't tried it, but there are directions in the (online) manual.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply