if you restore SQL 2005 on SQL 2008 you will not be able to make use of some of DMV's unless you change compatibility level to 100 and also you might get errors for few sql syntax like *= or =* (left joins & right joins)