U need to setup a maintnence plan that backs up DB and transaction log, this will then shrink it. If it is really big, u may need to set the backup to occur quite often.
> -----Original Message----- > From: Douglas Humphris [mailto:Douglas.Humphris@;unitech.net] > Sent: 01 November 2002 10:35 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] SQL Transaction logs HELP! > > > Is anyone here good with SQL Server admin? > > We have a transaction log which has grown way too large and > won't shrink. We're tried backing up and restoring and still > won't shrink. Trying to stop it before it consumes the whole > hard drive...it seems to have an enormous amount of unused > space which it won't release. Anyone any ideas on how to > shrink this - or point me to a SQL group. > > TIA Doug > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
