Host 2005 Databases on 2008 R2 Instance

[Savil]

We have many third party applications that rely on SQL 2005 databases. My question is, am I able to host these on a 2008 R2 instance with compatibility set appropriately? Would there be any issues?

Thanks

 

[bborissov]

Yes you could,
but after you attach these DBs on your 200 R2 they can not be attached/restored back on SQL Server 2005.

Borislav Borissov
VFP9 SP2, SQL Server

 

[Savil]

Thanks Borislav

I've just discovered that the database would automatically be upgraded. The compatibility flag should be used a as temporary measure to test application connectivitety.