Many times the large size of transaction log file (.ldf) in microsoft sql is too big which leads to performance issues and loss of valuable disk space.therefore it's imperative to periodically do ...

I have a database on SQL Server 2000 which is about 6GB but the LDF file is 100GB. I have been doing some research on the matter and found out that I have several options. Switch to Simple mode ...

This change improves debugging by providing a log file named according to SQL Server specifications.

This change improves debugging by providing a log file named according to SQL Server specifications.

I have a SQL 2000 SP4 server and MOM 2005 is reporting that the tempdb database log file is getting to large. Sure enough, it the templog.ldf file is a little over 9GB in size.I honestly don't ...