Dear Sir, When we create a database .ldf , .mdf files are creating and these files are useful to restore database. But I saw in one server for tables also .ld files are creating, We can restore the data by table with load command at command prompt. Can you explain please how to install sql server for .ld files or how to create .ld files.

Thanks and regards, Rasheed

-- Anonymous, December 18, 2004

Answers

Rasheed,

.mdf is the standard name for the primary data file and .ldf is the standard name for the log files. However, SQL Server 2000 does not enforce this standard. It is probably the case that for that one server that file names with the .ld extension were specified for the log files. If you need to create log files with that extension, the CREATE DATABASE command will let you.

Hope this helps,

Eric

-- Anonymous, December 19, 2004