CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Matthew
Matthew

Reputation: 4607

Difficulty Restoring Database in SQL Server 2008 R2

Unfortunately, I am experiencing a problem restoring a database on my laptop.

This is the error message that is being displayed in SQL Server 2008 R2 Management Studio:

enter image description here

How can I solve this problem please?

Update

It seems that I have to update my SQL Server 2008 R2 to Service Pack 2. Am I correct? I tried using the link from Microsoft however it requires around 5 hours to download because of the slow download speed (my internet reaches up to 1.2 MB/s download speed so the problem is not on my part).

Is there an alternative place from where I can download SQL Server 2008 R2 Service Pack 2?

Upvotes: 0

Views: 561

Answers (1)

Pradeep
Pradeep

Reputation: 3276

Seems like you are running SQL Server 2008 and your database backup is from SQL Server 2008 **R2**. That is what I infer from above screen shot. It is not about service packs but about SQL Server releases which is not backward incompatible. Refer this blog to get to know versions of SQL Server. You will have to upgrade your server.

To know what is your SQL Server version, you can use Select @@version.

[Update] - Alternatively, you can generate SQL Server Scripts and data which is compatible with SQL Server 2008. If your database is not huge, this can work and it will be quick.

Upvotes: 3

Related Questions