#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2008
    Posts
    3
    Rep Power
    0

    Restore one table from database backup - MS SQL 2005


    I am running MS SQL 2005 database. I have incidentally removed one of my database table. Now, I would link to know if it is possible to restore one particular table from the available database backup. If it is possible then can anybody provide me the exact steps?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2007
    Posts
    47
    Rep Power
    7
    Not sure whethere this is a correct way or not, but when I faced similar situation I did following -

    1. Created new database.
    2. Restored my backup on that DB
    3. Copied required table to original DB from new DB.
    Last edited by r937; January 7th, 2010 at 07:33 AM.
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2009
    Posts
    334
    Rep Power
    246
    Thanks for the info, found this helpful as i was going round in circles trying to work out how I select a table from the backup.

    though i must say, this is yet another rediculous POS interface from MS that requires you to have to restore an entire database to a new database just to get a few records from a single table.

    Yeah WTG MS, once again your usual piss poor effort at supplying a user friendy SQL interface!
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    1
    Rep Power
    0

    Smile


    Hi
    Yes you can restore one table from database backup SQL Server 2005 with the help of SysTools SQL Recovery Software. This solution works well and restore your entire tables from backup even deleted tables also recover in safe and sound condition which is not overwritten.
  8. #5
  9. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2009
    Posts
    334
    Rep Power
    246
    I appreciate using 3rd party tools at a price can do the job.

    It's just a shame and frustrating that the GUI provided by MS with the SQL server is a bit lacking in features such as these!
    Free MP3 Dance Music Downloads

    To err is human; To really balls things up you need Microsoft!

IMN logo majestic logo threadwatch logo seochat tools logo