• We had lot of trouble while migrating from 2k to 2k5. And our applciation is so big that it took us months to finaly come to 2005; but all the dbs are still at level 80. since, this took this long, there were many code changes that went into the system since the upgrade. Now, I'm planning to change the cmpatibility level to 90; but I'm stuck since, I cannot run the Upgrade Advisor on the new databases as they reside on 2005 instance. All my servers, includign Dev/QA are in 2005 now. since my dbs are big in size, I'm finding it difficult to install a new 2K instance and restore the dbs. Can anybody clear my doubts -

    1) Can I restore the cmpt 80 db backups taken on a 2005 server on to a 2000 server instance?

    2) Is there any way, I can make Upgrade advisor to run against cmpt 80 dbs attached to a 2005 instance?

    3) Is there any scripts or so that will do the same purpose as Upgrade advisor.

    Thanks,

    --smk