Dear SQLers:

I decided to see if my simple, sample database code would work
elsewhere. I asked a co-worker at another location to run the code,
backup the resulting database, and send the backup to me.

When I try to restore with

restore database Banking
from disk=N'C:\cbs2dev\SQLServer\Banking.bak'
with norecovery, replace, stats=10

I get an error of

Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 10.50.1600.
That version is incompatible with this server, which is running
version 10.00.1600. Either restore the database on a server that
supports the backup, or use a backup that is compatible with this
server.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Why the incompatibility? Did I miss an option?

We are both using SQL Server 2008 Express.

Sincerely,

Gene Wirchenko

Hi Gene,

10.50 is SQL Server 2008 R2 whereas 10.00 is SQL Server 2008

Best,
Henk

On 18-04-2011 04:47, Gene Wirchenko wrote:

Oops, unintentionally hit send
I was gonna add: As it would seem, 2K8 cannot restore 2K8 R2 databases

Best,
Henk

On 18-04-2011 08:41, Henk van den Berg wrote:

On Mon, 18 Apr 2011 08:42:50 +0200, Henk van den Berg
<hvandenberg (AT) xs4all (DOT) nl> wrote:

That seems very strange to me. What big change was there?

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.

Do you have a URL for R2?

[snip]

Sincerely,

Gene Wirchenko

On 18-04-2011 20:31, Gene Wirchenko wrote:
It's explained over here:

http://social.msdn.microsoft.com/For...a-a1dbd82aec20
there.

Best,
Henk

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
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.

http://lmgtfy.com/?q=%22SQL+Server+2...ss%22+download

Then again, despite your incident with the backup, I would not really
recommend the rush.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) 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

On Mon, 18 Apr 2011 21:28:41 +0200, Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

[snip]

Cute. That does not work on my system since I run with
JavaScript turned off for most sites.

Well, I really would prefer that I am using the same version as
the rest of the company. I did find R2 and installed it.
Interestingly, they are from different areas. R1 is from
www.microsoft.com/downloads/... and R2 is from
www.microsoft.com/express/... Not the friendliest way of doing it.

Sincerely,

Gene Wirchenko