My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Restoring and Attaching is a one way street
The new RSS feed is here
Many people often ask how they can us a database in SQL
2000 that they have attached or restored to SQL2005.
Unfortunately this is a one way street, once upgraded the only way of using a
database in a previous version is to copy the schema and data manually. You
can't restore or attach a database even if the compatibility has been kept at
the previous version.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Restoring and Attaching is a one way street