Report

Open .mdf files [Solved]

Ask a question BjornPorgilsson 2Posts Wednesday May 24, 2017Registration date May 25, 2017 Last seen - Last answered on May 25, 2017 at 02:55 PM by BjornPorgilsson
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.

See more 
Helpful
+1
plus moins
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!
Leave a comment
Helpful
+1
plus moins
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
Leave a comment
Helpful
+0
plus moins
Thank you guys for your feedback and help. Thank you!
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!