question

What you will be going with systems DB ???

After restore, you might get some backup error on SQL server 2008, here is the solution for that

www.sqlServer-Training.com

Certainly seems like a good plan, as you've probably discovered there is no one-step upgrade from 7 to 2008. The only thing I would add is to carefully understand what functionality changes between 7 - 2000 and 2000 - 2008, so that when you discover issues after completing both steps, you will have an idea of which version to go back to make any necessary changes.

A few things that I would have added to this process. After restoring to 2000, I'd update the compatibility level to be sure it was set to 2000. Then I'd run the Microsoft Update Advisor to be sure that no deprecated code or structures find their way into the 2008 system. Then after the upgrade to 2008 I'd again update the compatibility level. Finally, this is required, but it's a good idea, manually update all the statistics on the database.

Other than these details, that's the approach I would have taken.

I am with Grant on this one. Get yourself to a supported level where you can run the Upgrade Advisor with confidence - sometimes deprecated features only bite you much later on in the process and tend to bite at 2AM when you are in REM sleep. Grant points out the compatibility level change and the stats refresh, often times both of those steps are forgotten. As Grant points out this is exactly what MS recommends, not a bad way to go.

Grant I would have given you +1 on your answer but I still have < 15 rep. points.

Thanks to everyone for your response. I tried to vote yes as far as your answers. However it says I need 15 to vote. I am very appreciative of everyone's time and knowledge.

 Bill