LDF and MDF files are the components of the SQL Server database. When you create a database in SSMS, these files are automatically generated. MDF file is the primary data file that stores data and ...

Transaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a ...

I'm not a DBA - my knowledge of SQL is limited to install, uninstall, backup, restore, troubleshoot connectivity, that sort of thing. That said, one of the servers I manage has a database that behaves ...

There isn’t a week that goes by that I don’t hear or read about an organization seeing ginormous transaction log (.ldf) files, while the associated data (.mdf) file is at the size it should be when ...