XPost: microsoft.public.sqlserver.programming   
   From: hvandenberg@xs4all.nl   
      
   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:   
   > 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)