.mdf files

What are .mdf files and how do I use or open them? I have two .mdf files, but have no idea how to open them. Thanks

Hello,

SQL Server databases comprise of at least one *.mdf (data) and one *.ldf (log) file.

In order to "utilise" the *.mdf, you'll need attach them to a db within SQL Server via the sp_attach_single_file_db procedure (as you state that you have only the mdf files) as such (the corresponding ldf (log) file will be created):

exec sp_attach_single_file_db 'NewDBNameHere', 'C:\MyMdfFileHere.mdf'

Cheers,

Rob

|||Thanks. I have another question then. Will the SQL Server Express be okay? If so, how?