XPost: microsoft.public.sqlserver.programming   
   From: hvandenberg@xs4all.nl   
      
   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:   
   > 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)