Our MSSQL Database server gets slow 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 a

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?
sgkgaglgAsked:
Who is Participating?
 
momi_sabagCommented:
DBCC SHRINKFILE (N'name' , 0, TRUNCATEONLY)
0
 
momi_sabagCommented:
you can shrink the log files
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you have to first ensure that you (regulary) backup the transaction log (BACKUP LOG statement, not the physical file itself).
that will mark the space used internally as reusable, and also the DBCC SHRINKFILE command above will then be able to effectively reduce the t-log file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.