As the heading says I need to restore SQL2008 database to SQL2005. Now before y'll start bashing me, I have set the database compatibility level to SQL2005 but I am still getting errors when restoring.
Thought the whole point of compatibility was to make sure it can also be used in previous versions!
Also, you are a bit ahead of the game so there is not much on the web (there's loads on 2005 to 2000 of course, much of which might apply). downgrade "sql server" 2005 2008 - Google Search
The only thought is that maybe a high availability technology might help (2005 introduced some new ones that weren't available in 2000)