Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Restoring after TRUNCATE TABLE Expand / Collapse
Author
Message
Posted Tuesday, March 8, 2011 8:53 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
Comments posted to this topic are about the item Restoring after TRUNCATE TABLE
Post #1075276
Posted Tuesday, March 8, 2011 9:02 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, November 2, 2014 7:52 PM
Points: 371, Visits: 717
Not sure I get the point of the trick question.
It should be clear that you can restore to ANY point in time (at each 15 minute interval in this example). However, restoring to the 9:30 state will not recover your TRUNCATEd table ... so was that thrown in as a red herring ?
If so, it got me ...
Post #1075277
Posted Tuesday, March 8, 2011 10:43 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:19 AM
Points: 1,939, Visits: 585
I learned something form this question., Nice question.

-----------------
Gobikannan
Post #1075310
Posted Tuesday, March 8, 2011 11:41 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 13,511, Visits: 11,300
Ol'SureHand (3/8/2011)
Not sure I get the point of the trick question.
It should be clear that you can restore to ANY point in time (at each 15 minute interval in this example). However, restoring to the 9:30 state will not recover your TRUNCATEd table ... so was that thrown in as a red herring ?
If so, it got me ...


The question asked: Is it now possible to restore to a given point in time?

It is possible, so the answer is certainly yes. The question didn't ask if it was possible to restore that specific table to any given point in time.


Anyway, nice question.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1075338
Posted Wednesday, March 9, 2011 1:00 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
Ol'SureHand (3/8/2011)
Not sure I get the point of the trick question.
It should be clear that you can restore to ANY point in time (at each 15 minute interval in this example). However, restoring to the 9:30 state will not recover your TRUNCATEd table ... so was that thrown in as a red herring ?
If so, it got me ...


Hi - I think you may have overthought things a bit - it wasn't meant to be a complicated or trick question, but just to find out if people thought that TRUNCATE TABLE somehow affected the validity of the transaction log. It doesn't.

Thanks for the feedback though, maybe I should have made the question clearer somehow.

Duncan
Post #1075361
Posted Wednesday, March 9, 2011 1:01 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
Gobikannan (3/8/2011)
I learned something form this question., Nice question.


Thanks, glad you liked it.

Duncan
Post #1075362
Posted Wednesday, March 9, 2011 1:04 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
Koen Verbeeck (3/8/2011)
Ol'SureHand (3/8/2011)
Not sure I get the point of the trick question.
It should be clear that you can restore to ANY point in time (at each 15 minute interval in this example). However, restoring to the 9:30 state will not recover your TRUNCATEd table ... so was that thrown in as a red herring ?
If so, it got me ...


The question asked: Is it now possible to restore to a given point in time?

It is possible, so the answer is certainly yes. The question didn't ask if it was possible to restore that specific table to any given point in time.


Anyway, nice question.


Thanks for the feedback. You read the question as I meant it to be read, so I hope you got it right!

Cheers,

Duncan
Post #1075365
Posted Wednesday, March 9, 2011 2:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:03 PM
Points: 2,278, Visits: 3,806
Thanks for the question Duncan. I had a feeling that this question was more at testing our understanding of the truncate statement than the recovery models.

Mohammed Moinudheen
Post #1075384
Posted Wednesday, March 9, 2011 2:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 24, 2014 5:46 AM
Points: 1,416, Visits: 804
Two points for this?
Great!!!
Post #1075396
Posted Wednesday, March 9, 2011 2:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 13,511, Visits: 11,300
Duncan Pryde (3/9/2011)

Thanks for the feedback. You read the question as I meant it to be read, so I hope you got it right!


I did




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1075397
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse