Our MSSQL2000 Database server gets slow every 2-3 days as the log files are not being cleared automatically. When I watch the Directory of data files it show old date in the Date modified column. The Date is modified after restarting server.
How could the problem be resolved?. What setting to be done in the server?