sql 2008 to 2005

Question

how to open sql 2008 database to sql2005 database suppose i have database tht is created in sql 2008...but i hav to open tht database in sql 2005..how can i do it

Jignesh Trivedi · Answer

hi Vikas before downgrade to sql 2005 check your any database objects (SP function table etc) are not using any feature of SQL server 2008. please refer below link it might help you to resolve issue. http://chamilaw.blogspot.com/2011/04/how-to-restore-sql-server-2008-to-sql.html http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/11/downgrading-from-sql-2008-to-2005.aspx hope this will help you.