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, or ...

Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine. Recently we performed ...