|
Home > Archive > MS SQL Server > December 2006 > failed to restore db from SQL 2005 to SQL 2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
failed to restore db from SQL 2005 to SQL 2000
|
|
| xiaomei 2006-12-14, 5:25 am |
| 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
| |
| Uri Dimant 2006-12-14, 5:25 am |
| 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
|
|
|
|
|