Open .mdf files [Solved/Closed]

Report
Posts
2
Registration date
Wednesday May 24, 2017
Status
Member
Last seen
May 25, 2017
-
Posts
2
Registration date
Wednesday May 24, 2017
Status
Member
Last seen
May 25, 2017
-
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.

3 replies


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!
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
1
Registration date
Thursday May 25, 2017
Status
Member
Last seen
May 25, 2017
2
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
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Wednesday May 24, 2017
Status
Member
Last seen
May 25, 2017

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