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 08, 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: Thursday, April 03, 2014 10:34 AM
Points: 3,352, Visits: 1,478
Comments posted to this topic are about the item Restoring after TRUNCATE TABLE
Post #1075276
Posted Tuesday, March 08, 2011 9:02 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 5:44 PM
Points: 368, Visits: 714
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 08, 2011 10:43 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:45 AM
Points: 1,719, Visits: 552
I learned something form this question., Nice question.

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 12,208, Visits: 9,172
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 09, 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: Thursday, April 03, 2014 10:34 AM
Points: 3,352, Visits: 1,478
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 09, 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: Thursday, April 03, 2014 10:34 AM
Points: 3,352, Visits: 1,478
Gobikannan (3/8/2011)
I learned something form this question., Nice question.


Thanks, glad you liked it.

Duncan
Post #1075362
Posted Wednesday, March 09, 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: Thursday, April 03, 2014 10:34 AM
Points: 3,352, Visits: 1,478
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 09, 2011 2:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:49 PM
Points: 2,263, Visits: 3,758
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 09, 2011 2:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 9:09 AM
Points: 1,337, Visits: 746
Two points for this?
Great!!!
Post #1075396
Posted Wednesday, March 09, 2011 2:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 12,208, Visits: 9,172
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