Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Narezdog
Starting Member
1 Post |
 Posted - 2009-09-05 : 02:06:05
|
| 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 |
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-09-05 : 03:16:55
|
| You can't go backwards with sql server. A sql server 2008 database can't be downgraded to 2005. Hope that helps. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-15 : 01:42:56
|
| You'll have to attach the DB to a SQL 2008 instance, script all the objects out, bcp all the data out and then recreate the DB on SQL 2005--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Need to re attach SQL DB