BjornPorgilsson2
Posts Wednesday May 24, 2017Registration date
May 25, 2017
Last seen
-
May 24, 2017 at 10:49 AM - Latest reply: BjornPorgilsson2
Posts Wednesday May 24, 2017Registration date
May 25, 2017
Last seen
- May 25, 2017 at 02:55 PM
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.
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!
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
has helped 1447 users this month