restore database from SQL 2000 to SQL 7.0

The Microsoft Knowledge has many articles on restoring a
database from SQL Server 7.0 to SQL Server 2000, but I
need to do the reverse. I know the process involving
Enterprise Manager and the .BAK file, but it doesn't seem
to work. Are the .BAK files created in SQL Server 2000
compatible with SQL Server 7.0? I have a hunch that
either the character set, sort order, or Unicode collation
are different among the two versions.To my knowledge you can not restore nor attach a 2000 database to a 7.0
server, you might need to use DTS.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Kyle" <kmitchell@.lmc-ny.com> wrote in message
news:33c501c36db7$9e09a1e0$7d02280a@.phx.gbl...
> The Microsoft Knowledge has many articles on restoring a
> database from SQL Server 7.0 to SQL Server 2000, but I
> need to do the reverse. I know the process involving
> Enterprise Manager and the .BAK file, but it doesn't seem
> to work. Are the .BAK files created in SQL Server 2000
> compatible with SQL Server 7.0? I have a hunch that
> either the character set, sort order, or Unicode collation
> are different among the two versions.