SQl Server Data base Restoreing Error

Question

0.00/5 (No votes)

See more:

Hello friends,

I am restoring database . But this error Occurs. Is there any way to solve this.
Except Scripting.

System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1617. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

Thanks & Regards
Neetesh

Posted 24-Apr-13 5:01am

Neetesh Agarwal

Updated 24-Apr-13 5:02am

v2

Add a Solution

Comments

ZurdoDev 24-Apr-13 11:02am

The error tells you your options. Is there something else?

Neetesh Agarwal 24-Apr-13 11:22am

I know that but my mean was without upgrading

ZurdoDev 24-Apr-13 11:27am

I know you are looking for a way around it. I don't think there is one.

Neetesh Agarwal 24-Apr-13 11:28am

OK. Thanks

CHill60 24-Apr-13 11:06am

Upgrade "this server" to SQL Server 2008 R2??

Sandeep Mewara 24-Apr-13 11:14am

Does not the error says all?

Neetesh Agarwal 24-Apr-13 11:22am

I know that but my mean was without upgrading

Sandeep Mewara 24-Apr-13 11:28am

AFAIK, no work around.

Neetesh Agarwal 24-Apr-13 11:35am

OK thanks, I am now upgrading

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2013-04-24T05:32:00

Solution 1

The error tells your options. Unfortunately (sort of), I don't know of any way around this. The database was created in a newer version of SQL than where you are trying to restore it to, and therefore, there are settings within the backup file that SQL does not know about.

Posted 24-Apr-13 5:32am

ZurdoDev

Comments

Neetesh Agarwal 24-Apr-13 11:36am

Thanks Sir, Now I am upgrading sql server ..........

ZurdoDev 24-Apr-13 11:36am

Good to hear.

Leo Chapiro 24-Apr-13 11:54am

+5 :)

SQl Server Data base Restoreing Error

1 solution

Solution 1

Add your solution here

Preview 0

SQl Server Data base Restoreing Error

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us