Paul Hartland
Paul.Hartland at orridge.co.uk
Fri May 27 02:11:10 CDT 2005
I have two files in my directory Genesis_Data.MDF Genesis_Log.LDF Genesis_Log.LDF is ever increasing and doesn't shrink, is there something wrong with the file or should I be truncating this manually PAUL HARTLAND Database Designer/Programmer paul.hartland at isharp.co.uk ISHARP DDI - 01922 472031 Mobile - 07730 523179 ISHARP (Information Services for Hospitality, Audit, Retail and Pharmacy) provide IT resources for the Christie Group Stock & Inventory Services companies. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: 26 May 2005 17:05 To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Truncate Log On Checkpoint The Transaction Log will automatically truncate after a backup...the best way to do this rather than the checkpoint is to schedule a transaction log backup at an interval that is fair for you. When your recovery model is set to full you can then restore up to the minute before failure. On 5/26/05, Paul Hartland <Paul.Hartland at orridge.co.uk> wrote: > To all, > > I want to be able to turn on the following option in a SQL > Server 2000 database - trunc. log on chkpt > but can't for the life of me see where I do this, I am quite > new to SQL Server and have never used this option before but think it > will be quite useful. > > Can anyone help me on this..... > > Thanks in advance for any help..... > > > PAUL HARTLAND > Database Designer/Programmer > paul.hartland at isharp.co.uk > West Midlands > England > ISHARP > DDI - 01922 472031 > Mobile - 07730 523179 > > > > _______________________________________________ > > * This message is confidential. > * This email, its content and any files transmitted with it are intended solely for the addressee and may be legally privileged and/or confidential. > * Access by any other party is unauthorised without the express written permission of the sender. > * If you have received this email in error you may not copy or use the contents, attachments or information in any way and any review, use, dissemination, forwarding, disclosure, alteration, printing of this information is strictly prohibited. Please destroy it and notify the sender via return e-mail. > * This email has been prepared using information believed by Paul Hartland to be reliable and accurate, but the company makes no warranty as to accuracy or completeness. In particular the author does not accept responsibility for changes made to this email after it was sent. > * Any opinions expressed in this document are those of the author and do not necessarily reflect the opinions of the company or its affiliates. > > The Orridge web site can be found at: > http://www.orridge.co.uk > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com