"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:33aucqF3pm2sjU1@individual.net...
> hi John,
> "John P." <anonymous@discussions.microsoft.com> ha scritto nel
> messaggio news:02fb01c4ec23$aed1ebe0$3a01280a@phx.gbl
> > We have a software program that uses MSDE and the log file
> > is currently at 7 gigabytes in size which is abnormal.
> > When I do a backup using the softwares utility the backup
> > is only about 12 meg but when i restore to a fresh install
> > of windows the log file is right back at 7 gigabytes.
> >
> > Whats wrong with the MSDE and how do it shrink/correct
> > this?
>
> please have a look at MVP SQL Server Tibor Karaszi excellnt article on how
> (and eventutally when) to shrink the transaction log at
> http://www.karaszi.com/sqlserver/info_dont_shrink.asp ; the article also
> contains links to Microsoft Knowledge Base to HOW TO articles to perform
> correct backup/shrink operation
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>

> We have a software program that uses MSDE and the log file
> is currently at 7 gigabytes in size which is abnormal.
> When I do a backup using the softwares utility the backup
> is only about 12 meg but when i restore to a fresh install
> of windows the log file is right back at 7 gigabytes.
>
> Whats wrong with the MSDE and how do it shrink/correct
> this?

> Also, make sure that the recovery mode is set to simple, for the
> database the log is growing for, if you are not doing transaction log
> backups.

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:33dedaF3t60usU1@individual.net...
> hi Derrick
> "Derrick Leggett" <derrickleggett@yahoo.com> ha scritto nel messaggio
> news:%23x$S3rG7EHA.1292@TK2MSFTNGP10.phx.gbl
> > Also, make sure that the recovery mode is set to simple, for the
> > database the log is growing for, if you are not doing transaction log
> > backups.
>
> about simple recovery model, I would not be that fast in changing it and
I'd
> consider my whole recovery strategy...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>