March 18, 2014 at 9:37 am
I am looking for a basic article that shows how truncate affects restores.
- a table
- a backup with data in the table.
- add some data
- a log backup.
- truncate the table
- a log backup
Show how recovery before and after the truncate works with restores of the full and logs, and what data is available. If you want to take a backup (full and/or log) while the truncate is in progress (uncommitted), that would be great.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 13, 2014 at 2:59 pm
Hi Steve,
Are you asking for an article on Point-In-Time recovery or is there anything more than that?
April 13, 2014 at 3:08 pm
Truncate table doesn't affect restores in any way. What exactly are you looking for, proof that truncate table is logged (and hence is rolled forward by a log restore)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 15, 2014 at 8:23 pm
GilaMonster (4/13/2014)
Truncate table doesn't affect restores in any way. What exactly are you looking for, proof that truncate table is logged (and hence is rolled forward by a log restore)?
yes
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 16, 2014 at 2:38 am
In that case, I'll take it. Won't be this month though. Is that OK?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2014 at 1:53 pm
That's fine. I know you're good for it.
Sometime.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 17, 2014 at 3:49 am
Steve\Gail,
I have written something on it. I may submit it today. You can check if it is good to publish.
P.S.: Like everybody else on SSC, I would always be interested in reading a Gail Shaw article on this :-).
April 17, 2014 at 3:52 am
Divine Flame (4/17/2014)
I have written something on it. I may submit it today.
Cool, I'll scratch it off my to-write list then.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 17, 2014 at 10:53 am
Divine Flame (4/17/2014)
Steve\Gail,I have written something on it. I may submit it today. You can check if it is good to publish.
P.S.: Like everybody else on SSC, I would always be interested in reading a Gail Shaw article on this :-).
Submit it and I'll take a look.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply