> Hi All,
>
> I ran sp_spaceused and the result is following:
>
> database_name database_size unallocated space
>
> DB1 6462.50 MB 1466.20 MB
>
> reserved data index_size unused
> 4108216 KB 1889512 KB 298952 KB 1919752 KB
>
> sp_helpfile gives me the following:
>
> name size maxsize growth
> DB1_dat 5609600 KB Unlimited 10%
> DB1_log 1008000 KB Unlimited 10%
>
>
> I have run dbcc shrinkdb as well as dbcc shrinkfile but everytime I see
> the same results.
> I think the db size is much more than it is.
>
> Could you please tell what the above results tell me and what to do?
>
> Thanks a million in advance.
> Best regards,
> mamun
>

> The transaction log accumulates data until a backup of the database is performed or the log is
> truncated.

"JT" <someone@microsoft.com> wrote in message news:ufwTbnZzFHA.4032@TK2MSFTNGP15.phx.gbl...
> The transaction log accumulates data until a backup of the database is performed or the log is
> truncated.
> You will also want to perform DBCC SHOWCONTIG to investigate the amount of data/index
> fragmentation and DBCC INDEXDEFRAG to resolve it.
> Microsoft SQL Server 2000 Index Defragmentation Best Practices
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
>
> "microsoft.public.dotnet.languages.vb" <mamun_ah@hotmail.com> wrote in message
> news:1128825232.882522.295020@g14g2000cwa.googlegroups.com...
>> Hi All,
>>
>> I ran sp_spaceused and the result is following:
>>
>> database_name database_size unallocated space
>>
>> DB1 6462.50 MB 1466.20 MB
>>
>> reserved data index_size unused
>> 4108216 KB 1889512 KB 298952 KB 1919752 KB
>>
>> sp_helpfile gives me the following:
>>
>> name size maxsize growth
>> DB1_dat 5609600 KB Unlimited 10%
>> DB1_log 1008000 KB Unlimited 10%
>>
>>
>> I have run dbcc shrinkdb as well as dbcc shrinkfile but everytime I see
>> the same results.
>> I think the db size is much more than it is.
>>
>> Could you please tell what the above results tell me and what to do?
>>
>> Thanks a million in advance.
>> Best regards,
>> mamun
>>
>
>