http://sqlblog.com/blogs/tibor_karaszi/archive/2011/07/10/article-released-about-moving-databases.aspxJust a short notice that I've released an article about moving databases between SQL Server instances: You find it at http://www.karaszi.com/SQLServer/info_moving_database.asp .enCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/tibor_karaszi/archive/2011/07/10/article-released-about-moving-databases.aspx#36758Sun, 10 Jul 2011 14:50:42 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:36758AaronBertrand<p>Thanks Tibor. </p> <p>One thing that I see come up a lot (and something you touch on briefly toward the end of the article) is people who develop on 2008 R2 Express or Developer on their workstation, and then try to backup/restore or detach/attach to a 2008 instance elsewhere. While this is primarily the fault of Microsoft's boneheaded naming convention for the most recent release, I wonder if your article could include a list of resources for getting around this? I listed a few on this StackOverflow question, but an article certainly has a longer shelf life.</p> <p><a rel="nofollow" target="_new" href="http://stackoverflow.com/questions/6639788/sql-server-2008-r2-express-mdf-file-not-attached-in-sql-server-2008-developer/">http://stackoverflow.com/questions/6639788/sql-server-2008-r2-express-mdf-file-not-attached-in-sql-server-2008-developer/</a></p> <p>Of course this isn't isolated to 2008 R2 -&gt; 2008 migrations, but any that go &quot;backwards.&quot;</p> http://sqlblog.com/blogs/tibor_karaszi/archive/2011/07/10/article-released-about-moving-databases.aspx#36768Mon, 11 Jul 2011 03:55:08 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:36768TiborKaraszi<p>Got it, Aaron! :)</p>