backup restore between sql 2000 2005

hi to all ,
Is it posible to backup a sql 2005 db and restore it to an sql 2000 database
,
I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
restore it to 2005 but could not manage to the reverse of it
any help will be appreciated
regards...
orcunNo, it is not possible. If you need to get the data back to SQL Server
2000, you'll have to use DTS, SSIS, or a similar mechanism.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"orcun usturali" <orcun usturali@.discussions.microsoft.com> wrote in message
news:7FC04DA0-6AFA-49DB-8B84-BCD1B3F4A7DA@.microsoft.com...
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000
> database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db
> and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||No. You cannot restore or attach a 2005 database to 2000. So your options ar
e script and BCP, DTS,
SSIS and such tools that doesn't work at the binary level.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"orcun usturali" <orcun usturali@.discussions.microsoft.com> wrote in message
news:7FC04DA0-6AFA-49DB-8B84-BCD1B3F4A7DA@.microsoft.com...
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 databa
se ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db an
d
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||No. It does not work.
According with the speaker in the Microsoft Event, the system tables
structure of SQL Server 2005 are different than the ones in SQL 2000,
therefore you cannot go back from newer to older version.
"orcun usturali" wrote:

> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 databa
se ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db an
d
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||Could you tell me how do you restore the backup sql 2000. I 've got an error
when I restore a database saved by sql2000.
thanks for your help
"orcun usturali" wrote:

> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 databa
se ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db an
d
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||Just execute the RESTORE command, just as if you would restore onto a 2000 s
erver.
Can you post the RESTORE command you executed and the error message?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PBENISTY" <pbenisty@.newsgroups.nospam> wrote in message
news:C17F6E09-3525-43ED-B1F5-A0CE00EDB518@.microsoft.com...[vbcol=seagreen]
> Could you tell me how do you restore the backup sql 2000. I 've got an err
or
> when I restore a database saved by sql2000.
> thanks for your help
> "orcun usturali" wrote:
>|||Sorry
? didnt correctly understand what do you mean
my mail adress is orcunu@.biltas.com.tr
if you want to ask for anything lets continue on this mail adress
"PBENISTY" wrote:
[vbcol=seagreen]
> Could you tell me how do you restore the backup sql 2000. I 've got an err
or
> when I restore a database saved by sql2000.
> thanks for your help
> "orcun usturali" wrote:
>sql