February 15, 2013 at 7:57 am
HI All,
Can we restore/recover individual Table in Microsoft SQL Server. As far as i know it is not possible Out of the box. I dont want to use any third party due to cost issue.
Is there any work around to achieve it. Thanks.
Regards,
Inder
February 15, 2013 at 8:02 am
Hi Inder,
The short answer is no, you cannot natively restore a single table. Without a third-party tool your best bet is probably to restore the database somewhere else and copy the table you need back to your desired destination.
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
February 16, 2013 at 1:02 pm
Thanks Bob.
February 17, 2013 at 5:55 am
Hi
You can import /export table from source database to destination database .
February 26, 2013 at 6:33 am
RedGate has a wicked awesome tool called Virtual Restore. I can't remember the limitations but they do offer a ...wait for it...
<angels singing>
--->[FREE]<---
</angels singing>
trial. If cost is an issue and the database isn't massive, give it a whirl. Then you can say "wicked awesome" too.
If the database is massive and the free VR trial doesn't touch it, I'd suggest just buying a copy. We're talking a couple hundred bucks so the bank won't get broken. Heck, your company's executives probably spent more than that on wine and cheese at their last meeting.
March 20, 2013 at 8:03 am
Your Name Here (2/26/2013)
RedGate has a wicked awesome tool called Virtual Restore. I can't remember the limitations but they do offer a ...wait for it...<angels singing>
--->[FREE]<---
</angels singing>
trial. If cost is an issue and the database isn't massive, give it a whirl. Then you can say "wicked awesome" too.
If the database is massive and the free VR trial doesn't touch it, I'd suggest just buying a copy. We're talking a couple hundred bucks so the bank won't get broken. Heck, your company's executives probably spent more than that on wine and cheese at their last meeting.
Ah yes, but cheese and wine is far more important....! :w00t:
March 21, 2013 at 9:05 am
Red-Gate VR is awesome and could be a big win here. ApexSQL also has a Recover tool that can re-constitute tables, DML actions and recoveries, etc, buy using database/log files and/or backups.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 21, 2013 at 12:50 pm
The ability to recover tables is in my opinion one of SQL Servers weakest Points. For us that was so critical for a particular application that we opted for Oracle instead! Perhaps something that Microsoft should think about as an improvement to the product?
March 21, 2013 at 1:18 pm
I may be wrong but I think [not] putting this functionality in the product encourages third party vendors to "partner" with MS to provide add-on products, spreading the wealth...
I just want to get my arms around this "we chose Oracle over SQL Server because we could recover a single table in Oracle" thing. The only way I know of to recover a single table from an Oracle backup is to restore the whole backup somewhere and then extract the data and structure from the table.
Let me guess: you do an export of the entire Oracle database to be able to restore a single table.
March 21, 2013 at 1:26 pm
Ahhh.....the Beauty of Oracle!
Restoring a table can of course be done by extracting the table from a dump but easier is to ENABLE_ROW_MOVEMENT on the table in question.
You can then FLASHBACK TABLE until time or SCN (if you need it). If someone performs a DROP TABLE it is possible to recover it from the $RECYCLEBIN as long as the clever Person doesn't DROP with PURGE!
It obviously wasn't the only reason we chose it but it was certainly a key factor.
March 21, 2013 at 1:39 pm
Got it. I understand now. I just had to laugh at [what I thought] was a ...less than informed... choice.
I agree with you: MS could definitely put some bells and whistles on their backup/restore solutions. I'm still bummed they don't allow SQL Standard to do backup compression.
I attended a "preview" conference call yesterday with Oracle reps discussing Oracle 12c. One of the features was multiple databases under one instance. What a concept! If this "keep up with Microsoft" strategy keeps up, they'll be giving away OEM free with a purchase of the product.
<Hearty LOL>
March 21, 2013 at 2:07 pm
My apologies to all SQL Server Central readers in this thread.
It's amazing how a conversation 10 minutes before posting can influence the thought process. I'd just had a discussion about SQL 2008 Standard not compressing backups and actually inferred that [all versions] of SQL Standard didn't allow compression when in reality, MS switched gears to a more generous feature set in SQL 2008 R2 which does allow compression.
I still had the thought process of explaining to someone that SQL 2008 didn't allow it, when I posted.
Cheers,
Ken
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply