Post reply

SQL 2008 Table Restore

  • July 13, 2010 at 8:57 am

    #387340

    Greetings forum,

    quick question about restoring a single table in SQL 2008.

    Does anyone know if restoring a single table from a backup file will also restore the associated indexes/keys?

    Appreciate any experience anyone can share.

    Regards,

    Reuben.

  • July 13, 2010 at 9:01 am

    #1192102

    You cannot restore a single table.

    You will need to restore to another db/server and copy the one table across.

  • July 13, 2010 at 9:25 am

    #1192146

    That is what I thought, thanks for the prompt response!

  • July 13, 2010 at 9:33 am

    #1192164

    Quest SQL LiteSpeed can, but that does you know good in this instance. You would need a LiteSpeed backup in order to do an object-level restore.

    I only mention this product for future consideration as it indeed makes the life of a DBA somewhat easier. 😉

    As for what you can do here, the previous poster has the right of it.

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

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