URGENT: error on restored file

Posted on 2011-09-06
Last Modified: 2012-05-12
Hi experts,
SQL Server Version: 2008
I have a database in which the administartor made a backup copy of my database I need to restore it to my own server.
I tried to restore it but I get error:
The Database was backed up on a server running version  10.00.2531 (see attached file).

Seem that my version is incompatible.

Have you any idea How Can I restored my file or upgrade sql server?

Question by:ralph_rea
  • 2

Expert Comment

by:Andrei Fomitchev
ID: 36487721
1. Backup is not compatible from newer version to older.
2. You can use different options:
b. Export / Import
c. DB copy

Author Comment

ID: 36488230
Cannot I update my SQL Server with service pack??

Accepted Solution

FreelanzWithUs earned 500 total points
ID: 36489706
Apply SP1 for SQL 2008,

For more details follow the below link

Author Comment

ID: 36510004
I have applied SP1 for SQL 2008 but nothing has changed.

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Replication question 9 42
convert null in sql server 12 34
SQL SERVER 2008 R2 Could not obtain information about Windows NT group/user 5 36
Tsql query 6 22
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question