|Subject:||SSE 2008: Backup and Restore of Databases Across Different Subversions|
|Posted by:||Gene Wirchenko (gen…@ocis.net)|
|Date:||Sun, 17 Apr 2011|
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
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
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.