XPost: microsoft.public.sqlserver.programming   
   From: esquel@sommarskog.se   
      
   Gene Wirchenko (genew@ocis.net) writes:   
   > On Mon, 18 Apr 2011 08:42:50 +0200, Henk van den Berg   
   > wrote:   
   >   
   >>Oops, unintentionally hit send   
   >>I was gonna add: As it would seem, 2K8 cannot restore 2K8 R2 databases   
   >   
   >      That seems very strange to me.  What big change was there?   
      
   Generally, if there is a difference in the middle number in the version   
   number (00 vs. 50), you can expect differences. In this particular case   
   the difference is one single feature, as far as I know, Unicode compression.   
   (Which ironically is available only in Enterprise Edition.) R2 was as   
   far as the Database Engine is concerned a miniscule release. But R2   
   includes tons of stuff in the BI area.   
      
   >     How do I download R2?  I have tried in the past, but links were   
   > not accurate, and I got something that was incomplete and another   
   > time, I think it was the same as I already had.   
      
   http://lmgtfy.com/?q=%22SQL+Server+2008+R2+Express%22+download   
      
   Then again, despite your incident with the backup, I would not really   
   recommend the rush.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)