Groups > comp.databases.ms-sqlserver > #352

Re: SQL Server 2008 R2 vs SQL Server 2008?

From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SQL Server 2008 R2 vs SQL Server 2008?
Date	2011-05-18 13:51 -0700
Organization	A noiseless patient Spider
Message-ID	<g7c8t6dub7qduee24abhr5fnoli1g3dhmt@4ax.com> (permalink)
References	<29958c1e-cb26-407c-acd7-ba64dca39f5c@t16g2000vbi.googlegroups.com>

Show all headers | View raw

On Wed, 18 May 2011 12:01:41 -0700 (PDT), Joe Cool
<joecool1969@live.com> wrote:

>What are the differences between the two?
>
>Is there an advantage to use R2?
>
>Is there any reason to even use the non-R2 version?

     One difference that I found is that backups between the two
versions are NOT compatible.  I was not using R2 and someone I had run
a test script was using R2.  He sent me a backup of the resulting
database, and I could not restore it.

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SQL Server 2008 R2 vs SQL Server 2008? Joe Cool <joecool1969@live.com> - 2011-05-18 12:01 -0700
  Re: SQL Server 2008 R2 vs SQL Server 2008? Gene Wirchenko <genew@ocis.net> - 2011-05-18 13:51 -0700
    Re: SQL Server 2008 R2 vs SQL Server 2008? Joe Cool <joecool1969@live.com> - 2011-05-20 14:52 -0700
  Re: SQL Server 2008 R2 vs SQL Server 2008? Erland Sommarskog <esquel@sommarskog.se> - 2011-05-18 23:47 +0200

csiph-web