I have a DB where I would like to maintain a fixed size and control it
by myslef.
I do not have the options: "Auto-Grow" and "Auto-Shrink" enabled.
>From time to time, without a notice, or any logging, the database files
gets shrinker and this causes a database full error.
As I wrote, I would like to maintain the size of the database by myself
and not automatioc by the DB server.
Please help me find out what can cause this problem and how to solve
this issue.
Thnaks,
- Ze'evCheck to make sure there isn't a maintenance job set up on the server
that shrinks the db.|||I do not have such a job defined.
This is really wierd...
Thanks!|||"egpo@.egpo.net" <giboni@.gmail.com> wrote in message
news:1140452128.413183.49760@.g14g2000cwa.googlegro ups.com...
> I do not have such a job defined.
> This is really wierd...
Could someone be executing a DBCC Shrinkfile|db as a scheduled task or
ad-hoc?
> Thanks!|||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 ?
Thanks !
- Ze'ev|||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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks Erland !!
No comments:
Post a Comment