About Mdf Structure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

About Mdf Structure

Hi.I wanna to write a program for retrieving data from mdf files such as sqlrecovery.
Because sometimes a recieve a mdf file which a cannot attach to Sql server.i Use the sqlrecovery program to retrieve data from mdf files but
this program is trial and data i received from this program not real.Table name not real.
i Need to understand the mdf structure file and ldf.
Thanks

[quote user="Hamid"]
Hi.I wanna to write a program for retrieving data from mdf files such as sqlrecovery.
Because sometimes a recieve a mdf file which a cannot attach to Sql server.i Use the sqlrecovery program to retrieve data from mdf files but
this program is trial and data i received from this program not real.Table name not real.
i Need to understand the mdf structure file and ldf.
Thanks
[/quote]
I don’t know the program you refer to. However the structure of database files is pretty well explained in "Inside SQL Server 2005: The Storage Engine" by Kalen Delaney. But honestly, I would rather spend the money for such a tool, before reinventing the wheel.
As for ldf files: As far as I know, Microsoft licenses the knowledge about the structure of these files to vendors of such tools. Either you buy such a license or you’ll be on your own. This is proprietary knowledge of Microsoft.
Hi.Thanks.but i wanna write this application myself.Because one of the work of my company is Data Recovery.Sometimes We recover mdf or ldf Data files which cannt attach to DB.I Need To this program.
But i dont know Where the start point.?
please Help me.
thanks

Okay, I see…
In that case I would suggest buying the "Inside SQL Server 2005: The Storage Engine" book I mentioned. Additionally you might want to get familiar with the DBCC PAGE and DBCC LOG commands. Although undocumented (still true, I think), you can find the syntax and example by searching the web. It might give you an idea about the structure of database files. Good luck [:)]

Can you let me know which API or code ou are using. May be i can help in that

[quote user="ajit41806"]
Can you let me know which API or code ou are using. May be i can help in that
[/quote]
Welcome to the forums.!
This thread is old (2007).
Thanks anyway.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |