it wont reduce it dymanically, it will only reduce it on a per file basis as requried.
-----Original Message----- From: Spike [mailto:spike@;spike.org.uk] Sent: 01 November 2002 11:04 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL Transaction logs HELP! I'm not so sure that will actually reduce the amount of disk space being used by the logfile. If not, there's some info that might be helpful here: http://p2p.wrox.com/archive/sql_server/2002-04/131.asp Spike Stephen Milligan Team Macromedia - ColdFusion Co-author 'Reality Macromedia ColdFusion MX: Intranets and Content Management' http://spikefu.blogspot.com > -----Original Message----- > From: Robertson-Ravo, Neil (REC) > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > Sent: 01 November 2002 11:52 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] SQL Transaction logs HELP! > > > yep, just use Query Analyser.... the Enterprise Manager is > good for some things, but its not suited for all! > > so if you want to shrink a log named FOO to 5 MB, then just use > > dbcc shrinkfile (foo,5) > > then press F5 > > > > -----Original Message----- > From: Douglas Humphris [mailto:Douglas.Humphris@;unitech.net] > Sent: 01 November 2002 10:48 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL Transaction logs HELP! > > > Thanks Neil, > > what's the dbcc command? Do I run from command prompt? > > D > > -----Original Message----- > From: Robertson-Ravo, Neil (REC) > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > Sent: 01 November 2002 10:40 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] SQL Transaction logs HELP! > > > run either a shrinkdb or a shrinkfile dbcc command : > > dbcc shrinkdatabase ([database],[percentage of free space]) > > dbcc shrinkfile ([transactionlog], [sizeyouwant]) > > You may be to terminate all active pid's to run these > commands (start/stop server should do it) > > Neil > > > > -----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] > > > > -- > ** 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] > > > -- ** 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]
