November 28, 2008 at 12:00 am
Hi,
I am having my database backup of previous day.
Is there any way by which I can recover only a single table not complete dbase from that backup?
Tool used for backup is LiteSpeed.
Thanks in advance.
November 28, 2008 at 2:06 am
only two ways are there
1. database snapshot can help you if you have implemented that
2. restore that database bak up with another name , transfer that tables by SSIS /TDS package , drop restored database .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 28, 2008 at 4:41 am
LiteSpeed does have the ability to do object restores from a full backup. I don't recall exactly how, it's been a while since I used the product. I seem to recall that you can access the option through the litespeed gui tool. It does take quite a while to do on larger backups.
May I suggest that you consult the litespeed manual to see exactly how to do it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2008 at 7:50 am
LiteSpeed Rapid Access to Backups: Save Time with Object Level Recovery
Backup and recovery activities divert expert resources from high-gain IT initiatives to role processes. Using LiteSpeed for SQL Server, you can restore only the specific database objects you need, reducing your backup and recovery costs substantially.
http://www.quest.com/documents/landing.aspx?id=2417&technology=&prod=&prodfamily=&loc=
or SSC's own LiteSpeed vs Red Gate thread
http://www.sqlservercentral.com/Forums/Topic583474-357-3.aspx
November 29, 2008 at 7:48 pm
You can also do this way If am correct:
Restore the backup of the database with a different name and stop the point just before the data loss/to the desired point of time
Copy the the table back into the original database.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply