Large Log File

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Kevin" <kevgrim@xxxxxxxxx>
Date: Sat, 10 Sep 2005 10:58:41 +0100

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??

.

Prev by Date: Re: sqlservr.exe doesn't relase the memory
Next by Date: Msde and backup-restore
Previous by thread: how to install MMC snapin
Next by thread: Msde and backup-restore
Index(es):
- Date
- Thread

Relevant Pages

Re: Changing database size
... shrink the log file even there are log records at the end of the log file? ... > DBCC SHRINKDATABASE ... >> database file size, ...
(microsoft.public.sqlserver.server)
Re: Changing database size
... > shrink the log file even there are log records at the end of the log file? ... >> DBCC SHRINKDATABASE ... >>> database file size, ...
(microsoft.public.sqlserver.server)
Re: MSSQL7 and WinXP
... is closing the database after all connected clients are disconnected. ... > We're closer to a solution to our problem with slow machines on a MSDE ... The entries in the log file were reduced to a more sensible ...
(microsoft.public.sqlserver.msde)
Re: How to attach db with missing log file?
... Start SQL Service ... Database fake will appear as suspect in EM ... I support PASS - the definitive, ... > allowing me to get past the missing log file, ...
(microsoft.public.sqlserver.server)
RE: Shrink File?
... As my understanding of you problem, you have a database with a data file ... in the log file. ... You can truncate only nonactive portion of the transaction log. ...
(microsoft.public.sqlserver.setup)