I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still waiting to hear back on whether it's a full edition or Express].
I know that I can't restore a database from SQL Server 2008 R2 to SQL Server 2005 Express, and I know that I can't even restore a database from SQL Server 2008 R2 to SQL Server 2008. BUT! Can I restore a database from SQL Server 2008 R2 to SQL Server 2008 R2 Express? The only difference here being that one is a full paid version, and the other is the express version. If so, I'll just update the SQL Server 2005 Express server to 2008 R2 Express.
Thanks in advance!