<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Backups
»
Table Level Rescovery/Restoration
12 posts, Page 1 of 2
1
2
»»
Table Level Rescovery/Restoration
Rate Topic
Display Mode
Topic Options
Author
Message
inderrathore
inderrathore
Posted Friday, February 15, 2013 7:57 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, March 24, 2013 6:50 PM
Points: 8,
Visits: 60
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
Post #1420560
SQL_Bob
SQL_Bob
Posted Friday, February 15, 2013 8:02 AM
SSC Rookie
Group: General Forum Members
Last Login: Saturday, May 18, 2013 8:01 AM
Points: 30,
Visits: 288
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
MCITP, SQL Server 2008 Administration & Development
Blog:
The Outer Join
Twitter:
@SQLBob
Post #1420564
inderrathore
inderrathore
Posted Saturday, February 16, 2013 1:02 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, March 24, 2013 6:50 PM
Points: 8,
Visits: 60
Thanks Bob.
Post #1420920
vivekinmadar
vivekinmadar
Posted Sunday, February 17, 2013 5:55 AM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 2:30 AM
Points: 24,
Visits: 143
Hi
You can import /export table from source database to destination database .
Post #1420969
Your Name Here
Your Name Here
Posted Tuesday, February 26, 2013 6:33 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 1:39 PM
Points: 130,
Visits: 513
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.
Post #1424054
kevaburg
kevaburg
Posted Wednesday, March 20, 2013 8:03 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 159,
Visits: 191
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....!
Post #1433233
TheSQLGuru
TheSQLGuru
Posted Thursday, March 21, 2013 9:05 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 3,581,
Visits: 5,123
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 at GMail
Post #1433847
kevaburg
kevaburg
Posted Thursday, March 21, 2013 12:50 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 159,
Visits: 191
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?
Post #1433977
Your Name Here
Your Name Here
Posted Thursday, March 21, 2013 1:18 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 1:39 PM
Points: 130,
Visits: 513
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.
Post #1433997
kevaburg
kevaburg
Posted Thursday, March 21, 2013 1:26 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 159,
Visits: 191
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.
Post #1434000
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
