Posted by Erland Sommarskog on 02/23/06 10:30

egpo@egpo.net (giboni@gmail.com) writes:
> I was thinking that someone did execute this, or a virus of somekind. I
> lready changed the password on the server.
>
> when executing:
> exec sp_dboption "DB_NME" I see that this option is enabled: "trunc.
> log on chkpt.
> ". Could this cause the problem of DB shrinker ?

No. That options means you are running in simple recovery. That is, SQL
Server truncates the transaction log after each committed transaction
(more or less). But unless autoshrink is on, that will not cause any
shrinkage.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: How to create SELECT?
• Prev in forum: Re: Tricky SQL question
• Thread view: Re: DB shrinks without request

[Reply to this message]