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.
>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
>> We have a database that has several procedures run
>> it overnight, these include an optimisation, and also
>> sqlmaint equivalent of DBCC CHECKDB.
>> The database has auto-shrink switched off, but the
>> database file size does still sometimes shrink. Why is
>> This is SQL Server v7 SP2 running on Windows NT4 SP6