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 []
[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.
