failed to restore db from SQL 2005 to SQL 2000

Hi, There,
We download SQL 2005 Enterprise edt for 180-day evaluations, before that,
the DB is running on SQL 2000 Std.

When we did the migration, we just detach all DB and uninstall the software
and installed with 2005 SQL, and again attached those DB previous working on
SQL 2000.

Now for some reason, we need the database from SQL 2005 to be restored in
the SQL 2000 STD, I tried either backup from SQL 2005 and restored on 2000,
or detached from 2005 and attached in 2000, both action failed.

Is that a back compatable problem?

Kindly advise some solution how I can achive that if I need the Db from 2005
to be restored in 2000 version.

Thanks for any suggestion.

RgdsS
Shermaine

Hi
> Now for some reason, we need the database from SQL 2005 to be restored in
> the SQL 2000 STD, I tried either backup from SQL 2005 and restored on
> 2000,
> or detached from 2005 and attached in 2000, both action failed.

You cannot restore the db back to SQL Server 2000. One method is to create
an empty database in SQL Server 2000 the by using DTS Package transfer the
data from SS2005 to SS2000


"xiaomei" <xiaomei@discussions.microsoft.com> wrote in message
news:5F3B4791-C2FF-4A97-9B9B- CB5C525D0D6D@microso
ft.com...
> Hi, There,
> We download SQL 2005 Enterprise edt for 180-day evaluations, before that,
> the DB is running on SQL 2000 Std.
>
> When we did the migration, we just detach all DB and uninstall the
> software
> and installed with 2005 SQL, and again attached those DB previous working
> on
> SQL 2000.
>
> Now for some reason, we need the database from SQL 2005 to be restored in
> the SQL 2000 STD, I tried either backup from SQL 2005 and restored on
> 2000,
> or detached from 2005 and attached in 2000, both action failed.
>
> Is that a back compatable problem?
>
> Kindly advise some solution how I can achive that if I need the Db from
> 2005
> to be restored in 2000 version.
>
> Thanks for any suggestion.
>
> RgdsS
> Shermaine