Post reply

Restoring database tables from a database backup

  • November 1, 2004 at 2:50 pm

    #161766

    HI.

    I have a database backup(.bak) and I want to know is it possible to restore from that backup just a few database tables? I've looked at the restore database option and I don't see where you can pick out certain tables, only the entire database. I know I can physically make a copy of these few tables but i was trying to use my nightly .bak to do the job

    Any suggestions?

    Juanita

     

  • November 1, 2004 at 3:29 pm

    #528539

    Restore the database backup to a new database then use DTS to replace the tables in the original database.  See "How to restore a database with a new name" in Books OnLine. 

    Greg

    Greg

  • November 1, 2004 at 3:38 pm

    #528541

    Got it !!! Thanks Greg !

     

    Juanita

  • November 1, 2004 at 10:58 pm

    #528559

    This soln will work for the smaller database .If in case server is not having sufficient space or takes long time to restore the complete database .This is not reasonable to restore complete database to get one table which is less than 1 mb.I have other soln for this

     

  • November 2, 2004 at 1:49 am

    #528574

    Could you please let us know what the 'Other solution' is.  I would be very much interested.

  • November 2, 2004 at 2:13 am

    #528579

    Me too!

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

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