name of the file specified by the AttachDBFilename value). This change improves debugging by providing a log file named according to SQL Server specifications.

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

Recommended Action If the log file name is important for an app, the app should be updated to expect the standard _log.ldf file name format.

I did not have SQL server installed on the server. Yes you did. Sharepoint backend is SQL. Run full backup of SQL databases. Keep the backups! Then in the SQL Management Studio shrink the log file ...