Thanks ,so what you suggest ,it should be equivalent to per day database growth suppose 20 MB so let mark as 20MB growth and put some fixed size and remove...

Thanks Tommy ,i have already run that and the issue here is it actually it is showing correct around 6MB of free space , so is it a normal scenario...

Thanks ,appreciate your time , so it looks 2GB of kernel and 2 GB for application is taken care by O/S and initially it is just mapping to physical memory...

Appreciate your reply and links ,one question on that

Inside SQL Server 2000 Memory Management by Ken Henderson says 'It is usually disk drive space. Specifically, it is space in the...

Thanks All for your comments ,much appreciated , so there is any supportive document to support this kind of scenario ?

below are the detail for our setup

below is the detail for our setup

publisher -SQL 2000

distributor-SQL 2005

subscriber-SQL 2000

Thank you guys ,you are always awesome ,All suggetions has been taken in consideration.

Thanks Again.

Thanks John for reply so it means for same databases i can not go Active-Active Cluster ,what about if i keep one default instance on one node and named instance...

 Thanks much Mohammed Uddin it really helps.

Thanks ,but i am deleting rows from trace database to claim some space on the drive but as soon as i delete the batch ,log file grows for this database...

Thanks much Mohammed and Ross

Thanks for your reply , changing profile like increasing time out and other settings did not work , sorry ,for taking table offline what does it mean ,please confirm if...

Thank you Guys , you are awesome.

Thanks Adam , but the issue i am getting for anonymous subscriber is when ever i am running snapshot agent it is taking full sync with out reinitialize also ,is...

it got resolved after rebooting the dist box