Open .mdf files

Solved/Closed
BjornPorgilsson
Posts
2
Registration date
Wednesday May 24, 2017
Status
Member
Last seen
May 25, 2017
- May 24, 2017 at 10:49 AM
BjornPorgilsson
Posts
2
Registration date
Wednesday May 24, 2017
Status
Member
Last seen
May 25, 2017
- May 25, 2017 at 02:55 PM
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.

Related:

3 replies

Blocked Profile
May 24, 2017 at 04:09 PM
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
morrishall
Posts
1
Registration date
Thursday May 25, 2017
Status
Member
Last seen
May 25, 2017
2
Updated on May 25, 2017 at 04:11 PM
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
BjornPorgilsson
Posts
2
Registration date
Wednesday May 24, 2017
Status
Member
Last seen
May 25, 2017

May 25, 2017 at 02:55 PM
Thank you guys for your feedback and help. Thank you!
0