attach 2005 db on 2000

I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
there any way to do this if I no longer have sql 2005 running? I detached
and saved the db, but I don't have 2005 running anywhere anymore.
Thanks, Andre"Andre" <no@.spam.com> wrote in
news:#p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl:
> I have a sql 2005 beta 2 db that I need to move back to a sql 2000
> box. Is there any way to do this if I no longer have sql 2005
> running? I detached and saved the db, but I don't have 2005 running
> anywhere anymore.
Unfortunately, I do not think so. It's quite possible to attach a SQL
Server 2000 to SQL Server 2005, but as far as I know not the other way
around.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||Bummer, that's what I was afraid of. Thanks for the reply.|||1. Create new database in SQL 2000
2. Genarete script from objtects on the SQL 2005
3. Execute this script on the SQL 2000
If you have data, use bcp utilities or DTS/SSIS to export and import.
Regards
Amish|||"amish" <shahamishm@.gmail.com> wrote in news:1136273968.474136.28240
@.g44g2000cwa.googlegroups.com:
> 1. Create new database in SQL 2000
> 2. Genarete script from objtects on the SQL 2005
> 3. Execute this script on the SQL 2000
> If you have data, use bcp utilities or DTS/SSIS to export and import.
Of course, there are only one problem: There are no SQL Server 2005
instance, so there is nowhere to create the scripts :) As far as I remember
from the original post, the situation is that he has a database detached
from SQL Server 2005, but no SQL Server 2005 instance.
He can install one though...
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||That they have to manage.
Regards
Amish|||No. The internal bits are different. You can not attach a 2005 database to
2000.
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Andre" <no@.spam.com> wrote in message
news:%23p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl...
>I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
>there any way to do this if I no longer have sql 2005 running? I detached
>and saved the db, but I don't have 2005 running anywhere anymore.
> Thanks, Andre
>|||Thanks all.
In fact, I did end up installing SQL2005 beta 2 on another box. Then the
fun began because that box didn't have enough disk space to hold my 2005 db
that I was concerned with. But fortunately I found the article that showed
my how to flip a traceflag so that I could connect the db to a network
share. That worked - and then I used Integration Services (dts) to transfer
the data to a new sql 2k db. Where there's a will, there's a way. :)
Andre