Solved

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

Posted on 2009-07-09
3
11,328 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
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…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now