Very Computer

by **Steve** » Fri, 21 Feb 2003 11:21:46

We have a database that has several procedures run against
it overnight, these include an optimisation, and also the
sqlmaint equivalent of DBCC CHECKDB.

The database has auto-shrink switched off, but the
database file size does still sometimes shrink. Why is
this?

This is SQL Server v7 SP2 running on Windows NT4 SP6

by **Uri Diman** » Fri, 21 Feb 2003 11:47:23

Steave
What is recovery model of your database?
Do you perform transact log backup?
Have you checked SQL Server Profiler?
Perhaps someone ran DBCC SHRINKDATABASE manualy

Quote:> We have a database that has several procedures run against
> it overnight, these include an optimisation, and also the
> sqlmaint equivalent of DBCC CHECKDB.

> The database has auto-shrink switched off, but the
> database file size does still sometimes shrink. Why is
> this?

> This is SQL Server v7 SP2 running on Windows NT4 SP6

by **Steve Overto** » Sat, 22 Feb 2003 18:27:45

How would I find out the recovery model? I have been
through the docs and can't find anything there
Transaction logs are backed up, but they are not truncated.
SQL server profiler only includes the sample traces and
these have never been run
Since I am the only one with access to the database I know
that no-one ran the DBCC SHRINKDATABASE command.

Any ideas?

>-----Original Message-----
>Steave
>What is recovery model of your database?
>Do you perform transact log backup?
>Have you checked SQL Server Profiler?
>Perhaps someone ran DBCC SHRINKDATABASE manualy

message

>> We have a database that has several procedures run
against
>> it overnight, these include an optimisation, and also
the
>> sqlmaint equivalent of DBCC CHECKDB.

>> The database has auto-shrink switched off, but the
>> database file size does still sometimes shrink. Why is
>> this?

>> This is SQL Server v7 SP2 running on Windows NT4 SP6

>.

by **Tibor Karasz** » Sat, 22 Feb 2003 20:00:08

If you aren't on 2000, then check out sp_dboption.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...

> How would I find out the recovery model? I have been
> through the docs and can't find anything there
> Transaction logs are backed up, but they are not truncated.
> SQL server profiler only includes the sample traces and
> these have never been run
> Since I am the only one with access to the database I know
> that no-one ran the DBCC SHRINKDATABASE command.

> Any ideas?

> >-----Original Message-----
> >Steave
> >What is recovery model of your database?
> >Do you perform transact log backup?
> >Have you checked SQL Server Profiler?
> >Perhaps someone ran DBCC SHRINKDATABASE manualy

> message

> >> We have a database that has several procedures run
> against
> >> it overnight, these include an optimisation, and also
> the
> >> sqlmaint equivalent of DBCC CHECKDB.

> >> The database has auto-shrink switched off, but the
> >> database file size does still sometimes shrink. Why is
> >> this?

> >> This is SQL Server v7 SP2 running on Windows NT4 SP6

> >.

Very Computer

Database file shrink if auto-shrink off

Database file shrink if auto-shrink off

Database file shrink if auto-shrink off

Database file shrink if auto-shrink off

Database file shrink if auto-shrink off