i have only 2 sections, general and security...i dont know whats the problem that its not showing all the sectio as suggested by you all. Any idea guys....

I reached in the properties and under it i have general section, which has the created and last modified date, and there is another section below general name security,...

i dont see any report defination in the report manager, can you tell me how exactly i can see that tab.

Thanks

Thanks for you too SC

saw the link but unable to understand, where to put the bak file location.

Thanks Manu....

Thanks to both David and Dick,

I ran the shrink command

USE distribution

GO

DBCC SHRINKDATABASE(N'distribution' )

GO

and it released all the unused space.

Thanks again for your help.

The distribution cleanup job ran successfully last night, and now its showing free space in the files, i tried to shrink it but its not shrinking, can anyone send me...

yeah, i will run this tonight after hours, and will see the size then also just see my post tomorrow, if i need your help again. I stopped the job...

Thanks David,

I hope everything will be alrite after this job is finished, we have this job running every 10mins, so after this is completed i dont think it will be...

yes, there is a job name "Distribution Clean up: distribution", It was not running since many days, i started it but its running more than 30 mins now, so after...

Mani,

just one question with you, doing the dbcc will do but will it affect the replication going on.

so how do you suggest to shrink this log file.

yeah this database is a subscriber in full recovery mode, and we dont do any t-log backups for this.

this database is a subcriber, will it affect the replication. if we change it to simple recovery mode.