Kevin wrote:
> Have a log file that seems to be growing out of all proportion to the
> database.
> Have tried SHRINKDATABASE and SHRINKFILE
> Get error message 'Cannot shrink log file because all logical files
> are in use'
> As all transactions completed ages ago, am puzzled as to why MSDE
> seems to want to hang on to such a big log file.
> How can I get MSDE to clear all the transactions, to the database, so
> can reduce the log file size??

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:3og1vbF55dn8U1@individual.net...
> hi Kevin,
> Kevin wrote:
>> Have a log file that seems to be growing out of all proportion to the
>> database.
>> Have tried SHRINKDATABASE and SHRINKFILE
>> Get error message 'Cannot shrink log file because all logical files
>> are in use'
>> As all transactions completed ages ago, am puzzled as to why MSDE
>> seems to want to hang on to such a big log file.
>> How can I get MSDE to clear all the transactions, to the database, so
>> can reduce the log file size??
>
> perform a BACKUP LOG
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_35ww.asp
> ) in order to consolidates aged transactions and clear all virtual
> logs... then shrink the log file..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>