Open .mdf filesSolved/Closed

Question

Hello, 

I am using MS SQL and have logs that are in .mdf and .ldf format.  It took us a while but we figured out how to get our new settings correct and coming in w3c format.  The olf files are still .mdf and I need to know what I can do to open them and view them.  I have no database experience and want to know if there is a program I can use to do so.  I have tried MSDEtoText.vbs and were unsuccessful running the script.  Any suggestions will be greatly appreciated.

System Configuration: Windows / Chrome 58.0.3029.110

ac3mark · Accepted Answer

If they are OLF files, wouldn't they be in OLF format?  It sounds like you are hacking secured forms.  If you are using SQL, then script the OLF file into a table!

morrishall · Answer

You could use a mdf open file tool <REMOVED>
But before if you don't have the ldf file, you can use this SQL command: 
sp_attach_single_file_db @dbname= 'databasename', @physname= 'C:\Users\Blake\Documents\Databases\databasefile.mdf'
or you can:
CREATE DATABASE TestDb ON
(FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDb.mdf')
FOR ATTACH_REBUILD_LOG
GO

BjornPorgilsson · Answer

Thank you guys for your feedback and help. Thank you!

Open .mdf files

3 replies

Similar discussions

Subscribe To Our Newsletter!