June 11th, 2008, 11:02 AM
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?
June 14th, 2008, 02:51 AM
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.
January 7th, 2010, 06:10 AM
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!
April 4th, 2013, 01:19 AM
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.
April 4th, 2013, 06:51 AM
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!
December 9th, 2014, 01:43 PM
Backup and Restore Single SQL Server Table
Originally Posted by thewebhosting
bcp "[MyDatabase].dbo.Customer" out "Customer.bcp" -N -S ServerName -T -E -U"xxxxxx" -P"xxxxxxx"
bcp "[MyDatabase].dbo.Customer" in "Customer.bcp" -N -S ServerName -T -E -b 10000 -U"xxxxxx" -P"xxxxxxx"