No ,it is Sql2000.what should I check then?

I am taking backup locally.Sometimes it takes longer time and some times it takes normal time.Database size vary only 10 mb to 20 mb.Is it for temporary blocks it takes...

I understand used and free space in database.but what do you mean by unused space in database.

thnks,

Litu Deb

I know how to shrink whole database and also individual file.

I would like to know if i shrink only the database what would be the impact

on database.how come it reduce...

Thanks it is really helpful information for me.

I have one more query:

If i shrink the whole database how caome it is possible to

shrink the main database(except log file).

Thnks,

Litu

This is MSSQL2000 not 2005.And the table has clusterd index.

I have run dbcc dbreindex on one table in sql server 2000 but I can not see any improvement on page dencity.the page size of that table is 36,8 extent.

Is...

I did not get any reply.

I can understand after log trucate full database backup is needed due to log sequence issue.

but can anybody tell me how does log truncate affect...

I am still in confusion..

can anybody please tell me what actually happens in virtual log when we shrink inactive transaction log.how it affects on log sequence.

Thanks,

Litu