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
ShermaineHi
> 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@.microsoft.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|||Hi, Uri,
Thanks for your good advice.
Is any limitation for the db transfer between SQL 2005 and 2000, Because I
am unable to register the 2005 in SQL 2000 server group, and vice verse.
I will try, thanks a lot.
Rgds
Shermaine
"Uri Dimant" wrote:

> Hi
> 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@.microsoft.com...
>
>|||Hi
SQL Server 2005 has a new dataype XML , SQL Server 2000 hasn't for example
"xiaomei" <xiaomei@.discussions.microsoft.com> wrote in message
news:D6DF67A7-1248-45E0-98A3-F7AE89E69573@.microsoft.com...[vbcol=seagreen]
> Hi, Uri,
> Thanks for your good advice.
> Is any limitation for the db transfer between SQL 2005 and 2000, Because I
> am unable to register the 2005 in SQL 2000 server group, and vice verse.
> I will try, thanks a lot.
> Rgds
> Shermaine
> "Uri Dimant" wrote:
>|||The transaction log format is also different. SQL Server has never been
downlevel compatible with any version - this is not new behavior with SQL
2005 -> 2000.
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
http://blogs.msdn.com/sqlserverstor...ne/default.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e$7bQe4HHHA.3468@.TK2MSFTNGP04.phx.gbl...
> Hi
> SQL Server 2005 has a new dataype XML , SQL Server 2000 hasn't for example
> "xiaomei" <xiaomei@.discussions.microsoft.com> wrote in message
> news:D6DF67A7-1248-45E0-98A3-F7AE89E69573@.microsoft.com...
>|||Dear Paul, Uri,
Thanks for your help.
Since I am new to SQL, I didn't expect the back-compitable issue, now it is
a big problem for me.
I tried to use DTS to export the database to 2000 server, but it is very
slow, for a 66MB data, it takes more than 40 mins to execute and also cause
one task failed, so in that case I need examine one by one which table was
copied, which not, that is a very big task, especially for my other DBs whic
h
are around 6GB.
Any other suggestion I can do?
Thanks very much.
Rgds
Shermaine
"Paul S Randal [MS]" wrote:

> The transaction log format is also different. SQL Server has never been
> downlevel compatible with any version - this is not new behavior with SQL
> 2005 -> 2000.
> --
> Paul Randal
> Lead Program Manager, Microsoft SQL Server Storage Engine
> http://blogs.msdn.com/sqlserverstor...ne/default.aspx
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e$7bQe4HHHA.3468@.TK2MSFTNGP04.phx.gbl...
>
>|||Yo, MICROSOFT:
Sit up and take notice:
If you are going to allow things like "Compatibility level 8.0" for
databases stored in SQL 2005, then those database need to be FULLY and
UNCONDITIONALLY compatible with SQL 2000 installations!
We, as DBA's, need the ability to backup a (version 2000) database in SQL
2005 and restore it to a SQL 2000 instance.
If not, then change the nomenclature of "Compatibility 8.0" to something
more descriptive, like "U R screwed"!
I can do it in Word 2003, Excel 2007, Access 2003, and any combination of MS
products and versions, BUT NOT IN SQL.
That sucks!
--
Todd Chittenden
"Paul S Randal [MS]" wrote:

> The transaction log format is also different. SQL Server has never been
> downlevel compatible with any version - this is not new behavior with SQL
> 2005 -> 2000.
> --
> Paul Randal
> Lead Program Manager, Microsoft SQL Server Storage Engine
> http://blogs.msdn.com/sqlserverstor...ne/default.aspx
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e$7bQe4HHHA.3468@.TK2MSFTNGP04.phx.gbl...
>
>