Downgrading SQL server 2008 to SQL Server 2005

Question

Are there any issues backing up a database from SQL Server 2008, and then importing it into SQL Server 2005? I had upgraded to SQL Server 2008, but 2008 seems to be too problematic so now I want to downgrade. Are there any problems in doing this?

Answer 1

Well, you won't be able to restore a 2008 backup to a SQL 2005 server.

Easiest way to do it is to use the "Generate SQL Server Scripts" wizard to create a script (including schema and data) that you can run on SQL 2005 to create the database. See http://www.devx.com/dbzone/Article/40531

But back to the original issue: what problems are you having with SQL 2008?