Backup SQL 2000 Database Restore it to 2005 and then log shipping

[NVVN]

Hi :)

I have database on SQL 2000 which I want to backup and restore it to
another SQL 2005 and then again restore to another one SQL 2005 server.

Because SQL 2000 is working server (legacy) I can not change
compatibility mode for database from 8.0 to 9.0 when I restore it on
first SQL 2005.

There are also need to SQL 2000 database to be backuped again... and
again and restore it to SQL 2005 and so on...

Is it possible to backup SQL 2000 database, then restore it to first SQL
2005 leave it in 8.0 compatibility mode on first SQL 2005 and then setup
log shipping to second SQL 2005 ? If that is not appropriate, do you
have any idea how can I daily backup from SQL 2000 and restore onto two
SQL 2005 (of course, anything but just not to upgrade SQL 2000) ?

[TheSQLGuru]

I believe that log shipping doesn't care about 8 or 9 compatibility mode.
If I were you I would do a test on a small test database first. Shouldn't
take more than 30 mins to an hour to do this test.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

"NVVN" <m...@we.com> wrote in message
news:MPG.25763ee7b...@msnews.microsoft.com...