As far as I know there is no table in SQL Server that keeps a history of what recovery model a database has been in. You can find the current...

Nope, it's a different version of the engine and backups aren't backwards compatible. You can restore a 2008 backup on 2008R2, but not the other way around.

Hi Dave,

SQL Server 2008 R2 is a newer release of SQL Server - not a service pack or update. It differed in price from SQL Server 2008 as well. For...