Post reply

Partial restore possible?

  • June 9, 2006 at 11:11 am

    #153032

    Hi, I have SQL Server 2005 Workgroup edition, and I stupidly overwrote one of the tables with bad data, so I need to restore it from backup.

    The thing is, I can't figure out how to do a partial restore of only one table.  Is this possible?

    I am primarily a .NET programmer rather than a DBA, so if this is a dumb question, that's why.

  • June 10, 2006 at 4:59 am

    #642961

    Its not possible to restore just a single table.

    However you could restore the backup of the database as a new database and then you use a cross database query to select the data from the table in the backup and put it into the table in question.

    hth

    David

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

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