SSE 2008: Backup and Restore of Databases Across Different Subversions

Giganews Newsgroups
Subject: SSE 2008: Backup and Restore of Databases Across Different Subversions
Posted by:  Gene Wirchenko (gen…@ocis.net)
Date: Sun, 17 Apr 2011

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

Replies