Attaching a Visual Web Developer 2010 Express SQL MDF to SQL Server 2008 R2 is not a good idea.
I was looking for a way to draw Entity Relationship diagrams, so I decided to use the SQL server management studio Diagram functionality. So I thought I'd be clever and attach the .mdf to my 2008 R2 in the studio.
While I was arranging the diagrams I realized that I needed to quickly add a primary key to one of the tables... So I did and saved.
When I was done I tried running the project. What a nightmare. The 2008 R2 server upgraded my mdf and so now I could not connect. The error said that the database file had been upgraded and that there was no downgrade path.
Then I decided to restore from a backup from yesterday. Nightmare 2. The .mdf was being held by a sql server running on my machine. So searching the web I found that stopping all the server instances, might help. NOT.
I ended trying to delete the file. No luck. Then I chose to use Unlocker 1.9.1 The file would not unlock. Fortunately, the unlocker gave me the option to delete the files on the next re-boot.
Finally, that worked and I could continue working.
No comments:
Post a Comment