Convert a 2008 SQL SERVER MDF info 2005 !

mrkeivan

Hey guys, as u guessed by now, I have a MDF and LOG file which were created in SQL Server 2008, and currently I don't have that. Is there anyonre who can give me an email address so I can send my files to him and he sends me the script, that way I can generate it in 2005 !!! I ve done alot of searching and found this as the only way !!! Thanx in advance

Vimalsoft Pty Ltd

Am trying to understand what your question.its not clear please try to explain again

Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Mycroft Holmes

You want to send someone an MDF and LOG file, have them attach the file to their server, then script out the entire database and return the script to you. You might want to elaborate, the size of the database would be rather important. Also, why not install SQL Express 2008 and do it yourself (other than the absolute nightmare that installing SQL 2008 is).

Ashfield

Hav you tried using sql2008 express? Its free, and I think you would be able to do what you need.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Lost User

What is the compatibility level of the database ? If it was set to 90 or lower, you could still attach it to SQL Server 2005.

mrkeivan

I want to send someone an MDF and LOG file, have them attach the file to their server, then script out the entire database and return the script to you.

mrkeivan

exactly ! Thats, I figures if someone has it installed already why go through all the trouble installing it!!! Its about 60 MB ! K

mrkeivan

When I try to attach it, I get this error saying that my server supports 661 and lower and the file I'm trying to attach is 665 !

Lost User

It means that you cannot attach it to an SQL Server 2005 instance. Why don't you try SQL Server 2008 Express. Its free :)

Mycroft Holmes

60mb is the least of your problems when installing SQL 2008, there is a problem in the installer that cannot find dotnet 3.5 sp1 somewhere

Never underestimate the power of human stupidity RAH