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 «««23456

Restoring after TRUNCATE TABLE Expand / Collapse
Author
Message
Posted Monday, March 14, 2011 9:05 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:43 AM
Points: 1,938, Visits: 1,162
nice question.

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #1077772
Posted Wednesday, March 16, 2011 5:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 3, 2012 5:59 AM
Points: 226, Visits: 109
mohammed moinudheen (3/9/2011)
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.
Post #1078859
Posted Friday, March 18, 2011 9:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 10, 2014 4:29 PM
Points: 1,082, Visits: 538
Duncan Pryde (3/9/2011)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


Acchkkk!!! I over thought it too! Just as I hit the answer I thought, " I'm over thinking this, aren't I?" Next time.
Post #1080498
Posted Monday, June 6, 2011 11:54 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:12 AM
Points: 395, Visits: 167


Nice trick question!
Post #1120485
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse