SQL 2000 Server ===> Memory Issue

[deva1]

Hi All,

In the SQL server machine the hard disk(C) memory is reducing everyday.I have 2 partions (C and D).C has the SQL Server instances and D has all the Databases and Backup.I have daily scheduled jobs running.I have purge programs that is running every night and purging the DTS logs.But my C memory is reducing everyday.


Anyone have any idea what will be causing this and what I can do to find and stop this?



Thanks
Nk

 

[tlbroadbent]

Do you really mean the disk space on the C drive is being reduced daily? Search the disk for files that are using the disk space. Once you find the files that are created or growing daily, you should be able to determine why the disk is being filled.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm