Solved

how to convert mdf file version 655 to 612 in sql sever

Posted on 2009-07-09
3
11,380 Views
Last Modified: 2012-05-07
mdf file version 655 to 612
0
Comment
Question by:meroscorp
3 Comments
 
LVL 51

Accepted Solution

by:
Mark Wills earned 250 total points
ID: 24819755
Well, you can't really. 655 is SQL Server 2008 and 612 is SQL Server 2005.

There are a few "gotchas" in VS2008. Not least of which is an assumption of SQL 2008.

Could also be your hosting site is not supporting SQL 2008.

Now... Before Anything else, back up your ASPNETDB.MDF data before doing any of the suggestions just in case.

The ASPNETDB.MDF and aspnetdb_log.ldf files get recreated the next time you run your application. So, you can try removing them from your App_Data folder (stop SQL server first).

Also, there are a few suggestions on : http://forums.asp.net/t/1432690.aspx
0
 
LVL 38

Assisted Solution

by:Jim P.
Jim P. earned 250 total points
ID: 24825544
Once a sql mdf/ldf is taken to the next level you can't go back. The only way is an Import/Export to a SQL 2005 db. You might be able to use the db publishing wizard.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question