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

Truncating the log Expand / Collapse
Author
Message
Posted Tuesday, August 4, 2009 11:50 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 8:44 PM
Points: 1,520, Visits: 739
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
Post #765252
Posted Wednesday, August 5, 2009 7:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
Honestly did not BOL or test but googled :))




View Siva Gurusamy's profile on LinkedIn

"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
Post #765426
Posted Thursday, August 6, 2009 7:25 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:13 PM
Points: 1,889, Visits: 2,036
DUMP is a desupported feature, and Microsoft plans on removing it, why would anyone be wanting to learn this now?
Post #766178
Posted Thursday, August 6, 2009 8:25 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:58 PM
Points: 2,561, Visits: 3,842
My question is why would you not want us to learn something by using BOL?
Post #766237
Posted Thursday, August 6, 2009 10:56 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 39,866, Visits: 36,208
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 2008, MVP
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

Post #766393
Posted Thursday, August 6, 2009 4:20 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 3:16 PM
Points: 2,548, Visits: 542
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
Post #766612
Posted Friday, August 7, 2009 8:21 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 8:44 PM
Points: 1,520, Visits: 739
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
Post #766977
Posted Friday, August 7, 2009 8:30 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 39,866, Visits: 36,208
Backup log ... with truncate_only is also gone in SQL 2008.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #766988
Posted Sunday, August 9, 2009 6:53 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 8:44 PM
Points: 1,520, Visits: 739
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
Post #767592
Posted Monday, October 26, 2009 6:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:01 PM
Points: 7,689, Visits: 9,415
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
Post #808616
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse