How to recover a single object from a backup media...

• Kiran Kumar

  SSC-Addicted

  Points: 463

  More actions

  July 23, 2007 at 9:24 am

  #125121

  Hai,

    Can any one tell me, how to recover a single/selected object from a backup media.

  For ex:

  1. I have a db with some tables and sprocs.

  2. I took the backup of my db.

  3. Later I created a new db and want to restore only a few/selected objects(from my tables, sprocs) from my previously taken backup file.

  Thanks,

  Y.Kiran Kumar.

  Regards,

  -Kiran

• Steve Jones - SSC Editor

  SSC Guru

  Points: 735610

  More actions

  July 23, 2007 at 9:57 am

  #721563

  I think Litespeed can do this. Not sure about the other backup tools.

  There is no way in SQL Server to do this other than restore the database as a new name, then copy out the objects.

• Will1922

  SSCertifiable

  Points: 7189

  More actions

  July 23, 2007 at 12:49 pm

  #721625

  If you have the space somewhere else, just restore it to a development server and then DTS the objects back over.

  ---

  Live to Throw
  Throw to Live
  Will Summers

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  July 23, 2007 at 4:15 pm

  #721714

  And of course your database must be in "Full" recovery mode.

  _____________
  Code for TallyGenerator