I am in process of moving our SharePoint 2007 instance to another server, I have done this before while maintaining the same SQL server version without problem. In this instance I am trying to put the Content DB that currently exists on SQL2005 SP3 to a SQL 2008 R2 server. When I try to connect the Content DB from the 2008R2 SQL server it fails with event log entries referring to schema not matching and invalid/missing stored procedures.
I have read it is possible to use SQL 2008R2 with SP 2007 and am guessing that would work if I build a new content DB. Has anyone tried to tackle moving the content db as described.
How I migrated the Content DB was to backup the existing 2005 DB, create a new DB on 2008 R2 and restore/overwrite with the file from 2005.