Table Level Rescovery/Restoration

  • 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

  • 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

  • Thanks Bob.

  • Hi

    You can import /export table from source database to destination database .

  • 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.

  • 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:

  • 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

  • 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?

  • 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.

  • 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.

  • 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>

  • 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