ldf & mdf

[sudipta]

what are ldf and mdf files
and how and when are they created?

[ramasp]

mdf is the extension of primary file.
ldf is the extension of transaction log file.
whenever u create a database, u have to name the above fiels.
Generally their location path is c:\programfiles \microsoft sql server\mssql\lo gs

[vinod]

.mdf is the default extension name of datafile.
.ldf is the default extension name of log file.

[martinroldan]

Ok, thanks I also needed to know what those files are, but what can I do if I only have them, I mean I have a file called asdb.mdf and another called asdb_log.ldf; how can I get the DB from them?
Martin

[BISHOP33]

.MDF and .LDF are usually associated with SQL. In order to view the data you will need SQL Server. The .MDF file is the primary file.

[martinroldan]

Yes, I know that, I have SQL Server 2005, but how can I upload these files?
Martin

[BISHOP33]

You need to attach the database to the default instance. (SQL Server) Once attached, you can view the tables or data in that .mdf file.