Re attach SQL database NEED HELP BAD>> :(

[narezdog]

I had SQL 08 and downgraded to 05'. i did not detach the DB before uninstall and now I need to reattach it in 05' but it errors everytime. Is there a way to reattach it eventho it was not detached?

Thanks

 

[mrdenny]

You can not take a SQL 2008 database and attach it to a SQL 2005 database. You will need to attach it to a SQL 2008 instance, script out the objects and create them on the SQL 2005 server, then use SSIS to copy the data over (or use the scripting wizard in SSMS to script out all the data as well as the table schemas).

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[KirbyWallace]

Just a thought... But...

...you might want to check and make sure that before you detach the database from SQL 2008 that you set the compatibility level back to 90 (SQL 2005).

SQL 2005 might not know what to do with a compatibility level that it "swears blind" doesn't exist yet, cause as far as it knows, IT is the latest and greatest. ;-)

 

[gmmastros]

Kirby,

Setting the compatibility back will not solve the problem. The only way to do this is the method that mrdenny describes.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mrdenny]

Kirby,
The compatibility level just tells the engine what version of commands to support when running SQL against the database. It doesn't change the way that the engine stores the data in the datafiles. If it did, then it would take forever to change a database on a SQL 2005 server from 90 to 65 as the data storage engine changes a lot between the two.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog