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

So I've got this MSSQL 2005 server that has over 2000 databases on it. Apparently a database got created or moved or something to a location it shouldn't be... and the file name does not reflect the ...