MSDE log file grown to 7 gig.

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?
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.shtmhttp://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
|||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:33aucqF3pm2sjU1@.individual.net...
> hi John,
> "John P." <anonymous@.discussions.microsoft.com> ha scritto nel
> messaggio news:02fb01c4ec23$aed1ebe0$3a01280a@.phx.gbl
> 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.shtmhttp://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
>
|||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.shtmhttp://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
||| He obviously needs to do that. Until he does though, there is no reason
to have the database in simple recovery mode. He then has a constant
maintenance nightmare and something extra to worry about. He should set it
to simple, figure out what he's doing, then reapproach the situation.
"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
> 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.shtmhttp://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
>