problem at restoring database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

problem at restoring database

Author

Topic

somy
Starting Member

12 Posts

Posted - 2012-05-15 : 07:29:53

I created a backup of my database at my website's control panel. and I want to restore it at local server. I searched and find some ways to restore it but each time I have the following error:

"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.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server."

can any body help me!!
I need to restore the database.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-05-15 : 08:06:10

That means:
Your backup was taken on "SQL Server 2008 R2 SP1"
Your destination system now is: "SQL Server 2008 RTM"

These two versions are not compatible.

No, you're never too old to Yak'n'Roll if you're too young to die.

prett
Posting Yak Master

212 Posts

Posted - 2012-05-17 : 06:21:40

We can only restored a backup database to a SQL Server that has higher version than the original SQL Server.
Check this article which has full information about it: Why this happens:
http://www.mytechmantra.com/LearnSQLServer/Unable_to_Restore_Database_From_Backup.html

somy
Starting Member

12 Posts

Posted - 2012-05-19 : 09:27:03

thank you for your guidance,
so, I should instal the sql server 2008 R2 SP1 on my computer.
I found some links to download from Microsoft website but, It was only updates that I couldn't use it, and there was an error that
[Error Message]
There are no SQL Server instances or shared features that can be updated on this computer.
========================================================================
can I install this version (sql server 2008 R2 SP1), on windows 7 and is there a link to download this version?

thank you,

ovc
Starting Member

35 Posts

Posted - 2012-05-19 : 13:09:25

Hi Somy?

is the target sql server an SQL Server express edition?
If not check the language of the SP1 you are downloading

prett
Posting Yak Master

212 Posts

Posted - 2012-05-23 : 07:27:30

quote:
Originally posted by somy

thank you for your guidance,
so, I should instal the sql server 2008 R2 SP1 on my computer.
I found some links to download from Microsoft website but, It was only updates that I couldn't use it, and there was an error that
[Error Message]
There are no SQL Server instances or shared features that can be updated on this computer.
========================================================================
can I install this version (sql server 2008 R2 SP1), on windows 7 and is there a link to download this version?

thank you,

I have checked system requirements for sql server 2008 R2 SP1, it can be install on windows 7. For more details click to:
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=26727

You can click to know another known issues when you install SQL Server on Windows7
http://support.microsoft.com/kb/955725

somy
Starting Member

12 Posts

Posted - 2012-05-24 : 15:04:02

I installed the sql server 2008 R2 SP1 successfully, but the query for restoring the backup file didn't work.
can any body help and post the querry for this action?
tanks for helping

prett
Posting Yak Master

212 Posts

Posted - 2012-05-25 : 02:31:41

Use Master
Alter Database db_Name
SET SINGLE_USER With ROLLBACK IMMEDIATE
RESTORE DATABASE db_Name
FROM DISK = ‘D:\dbName.bak’

Ref: http://sureshjain.wordpress.com/2008/02/16/restoring-bak-files-using-query-analyzer/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources