I need to set up a SQL Server for a development environment for a client. First I installed SQL Server 2008, I was able to connect to it from SQL Server Management Studio fine but when I tried to restore the .bak it said
the database was backed up on a server running version 10.50.2789.
That version is incompatible with this server, which is running
version 10.00.5500.
After googleing I found I needed SQL Server 2008 R2 to match that version number, so I downloaded that from the Microsoft website and ran it. But I keep trying to set up a new server instance so I can restore the .bak but it's still creating another instance in SQL Server 2008 when I install it with version number 10.0.1600.
Can anyone suggest how I can set up a server running version 10.50.2789?
Thanks
Best Answer
Follow the link given. You will get details that which versions are compatible with the different edition of SQL Server. Hope it will help you.