THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Article released about moving databases

Just 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.
Published Sunday, July 10, 2011 4:26 PM by TiborKaraszi

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

AaronBertrand said:

Thanks Tibor.

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.

http://stackoverflow.com/questions/6639788/sql-server-2008-r2-express-mdf-file-not-attached-in-sql-server-2008-developer/

Of course this isn't isolated to 2008 R2 -> 2008 migrations, but any that go "backwards."

July 10, 2011 10:50 AM
 

TiborKaraszi said:

Got it, Aaron! :)

July 10, 2011 11:55 PM

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement