March 8, 2005 at 10:16 am
Hello,
Is it possible to restore any single object from a complete backup. If yes, how can I restore a single table.
Thank you all.
March 8, 2005 at 11:05 am
Not without restoring the whole backup, no. What can be done is restore the backup to a temporary location and then move the data for the single table from that temporary database to where you need the data to be.
K. Brian Kelley
@kbriankelley
March 9, 2005 at 1:06 am
You cannot retrieve a single table from native SQL Server Database backup.
However, some of the backup-recovery tools provide this functionality.
SQL-Backtrack for SQL Server -- BMC Software.
This is a very good tool for retrieving a single object from a database. You can also have object level backups in this tool. You may want to try out the trial version of this tool. http://www.bmc.com
--Kishore
March 9, 2005 at 4:53 am
This can be done by using command restore database with partial option.
Also while creating the table if he has mentioned create table on filegroup (filegroup name) .
Hence while restoring with partial option only that particular data file can be restored in which it contains table.
March 9, 2005 at 7:25 am
LiteSpeed 2005 for SQL Server supports Object Level Recovery. The GUI is very intuitive and allows you to perform object recovery to a CSV file or to a new table using DTS. LiteSpeed's Object Level Recovery routines support both native and LiteSpeed backups.
Feel free to download the evaluation here - http://www.imceda.com/Download.htm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply