I have multiple DASP sites each with their own SQL Server database. They are at different versions of SQL Server. The two I'm most concerned about are these: 1. Version 10.50.6529.0 2. Version 10.0.6535.0 I have SQL Express and Management Studio loaded. The Express version is 10.0.2531.0. So, the database #2 above I can restore just fine from my DASP backup, but the first one (#1 above) gets error: "The database was backup up on a server running version 10.50.6529. That version is incompatible with this server, which is running 10.00.2351". So to what version of Express do I need to upgrade in order for BOTH of these to restore correctly? Thanks for any help!
I solved it - I didn't realize that Express and Management Studio were loading separate upgrades. I upgraded both and can now restore all my versions of backups locally.
