Post reply

about backup&recovery of some specific tables from database

  • March 14, 2012 at 7:07 am

    #270014

    Hi all

    Can anyone please guide::I f un a database there are 100 tables and we want to restore only selected tables from the backup??Is it possible??or can we restore some selected tables from the database.

    Please guide

    Regards

  • March 14, 2012 at 7:15 am

    #1459154

    Your talking about object level restores which are not avilabile in SQL as standard.

    I know LiteSpeed for SQL server from Quest Software has object level restores built in but this is an expensive product at around £2000 per server.

    The other way would be to restore the backup of the database as a different db, then use sql scripts to copy the objects from the source to the destination DB.

  • March 14, 2012 at 7:33 am

    #1459173

    thnx a lot for ur reply.Can we create a database and then restore the previous taken database backup and then by copying the required tables from that database.

  • March 14, 2012 at 7:36 am

    #1459178

    yes you can.

    easiest way would be to right click the database and then script the database as a create, then change the name and filepaths, then restore the backup into this new database and copy the objects you need

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

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