Viewing 3 posts - 16 through 19 (of 19 total)
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...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
April 9, 2012 at 9:56 am
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.
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
March 23, 2012 at 9:31 am
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...
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
March 23, 2012 at 9:23 am
Viewing 3 posts - 16 through 19 (of 19 total)