Truncating the log

Question

Truncating the log

Vinay Thankur

SSCarpal Tunnel

Points: 4178
More actions
August 4, 2009 at 11:50 pm

#208913

Comments posted to this topic are about the item Truncating the log
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Siva Gurusamy SSCrazy Points: 2711 More actions · Answer 1

Honestly did not BOL or test but googled :))

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 2

DUMP is a desupported feature, and Microsoft plans on removing it, why would anyone be wanting to learn this now?

OCTom SSChampion Points: 11785 More actions · Answer 3

My question is why would you not want us to learn something by using BOL?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Chris Harshman (8/6/2009)
DUMP is a desupported feature, and Microsoft plans on removing it

Dump is gone in SQL 2008.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLWinther SSCertifiable Points: 6294 More actions · Answer 5

GilaMonster (8/6/2009)
Chris Harshman (8/6/2009)
DUMP is a desupported feature, and Microsoft plans on removing it
Dump is gone in SQL 2008.

Yes, and have already forgotten the statement, since it has been desuported, but it he did not specify which version, so he fooled me 🙂

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform

Vinay Thankur SSCarpal Tunnel Points: 4178 More actions · Answer 6

Thank you all for all your comments....

This is my first post QOD to Sql server central...We have some sql server 2000 setup which we migrated from older version (I know its wierd but its true). I was working on it and found this intrested info so thought it could help someone (Sorry if i disappointed )... I know its old I thought to make it "Backup Log" than to make it complex made it "Dump" Which will not be their in Sql server 2008 (but good to know that this was their 🙂 )...

Will try to improve my self.

Thanx.

Vinay

http://vinay-thakur.spaces.live.com/blog/

Thanx.
Vinay

http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Backup log ... with truncate_only is also gone in SQL 2008.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Vinay Thankur SSCarpal Tunnel Points: 4178 More actions · Answer 8

http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!218.entry

Thanx.
Vinay

http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay

TomThomson SSC Guru Points: 104773 More actions · Answer 9

The BOL reference after the explanation doesn't help at all, as it doesn't refer the dump command. Anyway, even in SQL 2000 the dump command was deprecated, MS recommended that it be not used, and of course in the latest SQL Server it is no longer supported. The question would have been far better written using backup log instead of dump transaction.

Tom