If I've got a SQL 2005 database that I want to import to SQL 2008, but never
upgrade it to a 2008 database, can it be unmounted and re-imported back to
SQL 2005?


--
-Andy Stevens
Jr. Web Developer
Adams Keegan
http:\\www.adamskeegan.com
Re-think HR. Think Adams Keegan.

Hi Andy

What do you mean by 'import'? If you have attached or restored the database
so it is now used by SQL Server 2008, then the database is already upgraded
and cannot be attached or restored to a SQL 2005 instance.

--
HTH
Kalen
----------------------------------------
Kalen Delaney
SQL Server MVP
www.SQLServerInternals.com

"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote

I was just guessing on terminology, but you answered my question. Thanks!


--
-Andy Stevens
Jr. Web Developer
Adams Keegan
http:\\www.adamskeegan.com
Re-think HR. Think Adams Keegan.


"Kalen Delaney" wrote:

Sorry, no. Opening a database file with SQL Server 2008 will update certain
things in the database so that SQL Server 2008 can use it. (And it updates a
version number in the database.) But then SQL Server 2005 won't understand
those things, so you can't just go back to SQL Server 2005.
You could export the database from SQL Server 2008 back to a SQL Server 2005
using the Copy Database Wizard. But if you have used any SQL Server 2008
features (for example Extensible Key Management or the spatial data types)
you would have to exclude those.
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote