InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 05:43:46 GMT20http://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxMy apologies to all SQL Server Central readers in this thread.It's [b]amazing[/b] 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 [i]does[/i] allow compression.I still had the thought process of explaining to someone that SQL 2008 didn't allow it, when I posted.Cheers,KenThu, 21 Mar 2013 14:07:42 GMTYour Name Herehttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxGot 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>Thu, 21 Mar 2013 13:39:49 GMTYour Name Herehttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxAhhh.....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.Thu, 21 Mar 2013 13:26:52 GMTkevaburghttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxI 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.Thu, 21 Mar 2013 13:18:27 GMTYour Name Herehttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxThe 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?Thu, 21 Mar 2013 12:50:21 GMTkevaburghttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxRed-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.Thu, 21 Mar 2013 09:05:30 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspx[quote][b]Your Name Here (2/26/2013)[/b][hr]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.[/quote]Ah yes, but cheese and wine is far more important....! :w00t:Wed, 20 Mar 2013 08:03:29 GMTkevaburghttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxRedGate 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.Tue, 26 Feb 2013 06:33:25 GMTYour Name Herehttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxHi You can import /export table from source database to destination database .Sun, 17 Feb 2013 05:55:04 GMTvivekinmadarhttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxThanks Bob.Sat, 16 Feb 2013 13:02:34 GMTinderrathorehttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxHi 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.Fri, 15 Feb 2013 08:02:34 GMTSQL_Bobhttp://www.sqlservercentral.com/Forums/Topic1420560-357-1.aspxHI 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,InderFri, 15 Feb 2013 07:57:16 GMTinderrathore