Can we do logshipping from sql 2005 to 2000? How it is different between 2 SQL versions?
This was the question asked by one of the user in the forums.
Precisely the answer is no, as you cannot restore a log or database from SQL 2005 to 2000 version due to the differences in the design. Moreover for the sake of high availability the method of performing Log shipping between 2005 and 2000 instance will not be valid, as in case if you need to restore the database if any issues on primary server then it is not allowed, as you can restore from 2000 to 2005 but not reverse-way. It doesn't server the purpose of providing high availability to your database, you may be asking this question just for information but if the destination in 2005 theres no point in configuring it with older technology, where you can take advantage from native methods.
Then coming to the differences between SQL 2000 and 2005, Steve Jones has documented the information here.