Large Log File

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?
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/de...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.shtmhttp://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
|||Works brilliantly well - Thanks Andrea
Kevin
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3og1vbF55dn8U1@.individual.net...
> hi Kevin,
> Kevin wrote:
> perform a BACKUP LOG
> (http://msdn.microsoft.com/library/de...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.shtmhttp://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
>