Backup from SQL Server 2005 - restore to 2000

I need to restore a backup of a db in SQL 2005 with 80-compatibility level
into SQL Server 2000. I have tried to do it but I have an error. Is it
possible to do it?
Does exist another fast method to bring a SQL Server 2005 db into 2000?
Many thanks for your suggests.
I known this answer, but I hope if possible with a SQL Server 2005 db in
80-compatibility level.
Using import/export wizard is less quick.
Thanks
"Zarko Jovanovic" wrote:

> Pasquale wrote:
> you cannot restore 2005 database to 2000 server
> try using import/export wizard
> gl
>
|||Ok!
I hope to do it because the db in SQL Server 2005 is the result of a db
backupped into SQL Server 2000 and restored into 2005 with 80 compatibility
level.
Many thanks.
"Zarko Jovanovic" wrote:

> Steen Schlüter Persson (DK) wrote:
> just to acknowledge that: no, you cannot restore or attach or anything
> with 2005 database on 2000 server no matter compatibility level
>
|||"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:46033DC3-842B-488F-8844-5BAB0411064C@.microsoft.com...
> Ok!
> I hope to do it because the db in SQL Server 2005 is the result of a db
> backupped into SQL Server 2000 and restored into 2005 with 80
> compatibility
> level.
Correct, you can restore a DB from SQL 2000 to 2005, but you can not under
any circumstances do the reverse.
The 80 compatibility only refers to features available, etc. The structure
itself is still a 2005 DB.

> Many thanks.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html