Post reply

sql server 200 restore selected table

  • December 14, 2001 at 12:08 pm

    #158052

    I would like to find out if I can restore tables selectively from a backup.

    Thanks in advance for your help

  • December 14, 2001 at 2:08 pm

    #421142

    Unfortunately no, you will have to restore the whole backup. However, you can restore to another place or another name and then copy the specific table back using DTS or whatever other method may be of your liking.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • December 14, 2001 at 2:29 pm

    #421145

    No single table restore. David is correct.

    Alternatives:

    If you use filegroups, you only have to restore the filegroup (somewhere). This may be helpful for large dbs.

    If you made a mistake in data updates, then Log Explorer (one of our advertisers) has a great product to help you undo issues.

    Steve Jones

    steve@dkranch.net

Viewing 3 posts - 1 through 2 (of 2 total)

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