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 ...
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 ...
SQL novice here! Just set up an SQL 2005 server, there is currently 1 database sitting in the default SQL location on C Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. I went to properties and ...