When trying to restore a backup file (
.bak) to SQL Server installed on my machine, I get the following error (steps that I follow to restore are: Right Click Database ---> Tasks ---> Restore)
The database was backed up on a server running version 10.50.2500. That version is incompatible with this server, which is running version 10.00.2573. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
I have SQL Server 2008 R2 on my machine and under Help --> About, I see the following:
Microsoft SQL Server Management Studio 10.50.1600.1 Microsoft Data Access Components (MDAC) 3.85.1132
Question: I already have Service pack 2, what should I down and from where to be able to restore my back up.