| Author |
 Topic  |
|
|
srobison62
Starting Member
17 Posts |
 Posted - 08/07/2012 : 09:23:25
|
Hey guys I spent the better part of yesterday trying to figure this out, so I thought maybe yall could give me a hand. I am trying to open up the data file for our company but whenever I do I get this error message.
" system.data.sqlclient.sqlerrorL: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server which is running version 10.00.5500."
This seems fairly obvious to me that I need to upadte my sqlclient but for the life of me I cannot figure out how to. I have downloaded patches, done windows update, but I cant get it to work. Any help would be greatly appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48064 Posts |
Posted - 08/07/2012 : 09:47:08
|
you've to either backup on compatible server or you need to upgrade source server to correct version.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
srobison62
Starting Member
17 Posts |
Posted - 08/07/2012 : 09:51:41
|
I just downloaded another patch to try but now it wont even let me log in as either sa or locally, I am trying to log into ./SQLEXPRESS but it says TITLE: Connect to Server
------------------------------
Cannot connect to .\SQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48064 Posts |
Posted - 08/07/2012 : 10:02:02
|
see if sql service is running first in machine
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
srobison62
Starting Member
17 Posts |
Posted - 08/07/2012 : 10:15:40
|
| No I cannot find SQL in the services list |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48064 Posts |
Posted - 08/07/2012 : 10:16:30
|
are you sure you're looking at the correct machine? ie machine where sql server is running?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
srobison62
Starting Member
17 Posts |
Posted - 08/07/2012 : 12:01:53
|
| I am on a local machine, I reinstalled sql and I can now log in. However I am still getting the version 10.50.1600, is incompatible with 10.00.1600 any ideas? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48064 Posts |
Posted - 08/07/2012 : 12:08:09
|
as i told you're trying to restore from a backup created using higher version server onto your lower version server. so you've to install higher version server on your machine if you want to restore the backup created from other server which is of later version
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
srobison62
Starting Member
17 Posts |
Posted - 08/09/2012 : 09:15:46
|
| Right, when you say higher version can you tell me what you mean exactly? I am running sql server express R2 2008, if its an update you are talking about, none of them seem to do anything. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48064 Posts |
Posted - 08/09/2012 : 09:55:19
|
quote:
Originally posted by srobison62
Right, when you say higher version can you tell me what you mean exactly? I am running sql server express R2 2008, if its an update you are talking about, none of them seem to do anything.
i'm taking about server version as it is
the error message says like you've initially done back up in server with version 10.50.1600 which is SQL Server 2008 R2 RTM
now you're trying to restore it to server running version 10.00.5500 which is sql server 2008 sp3 . it wont allow backup taken on a higher version server to be restored onto a lower version server which is why the error
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
srobison62
Starting Member
17 Posts |
Posted - 08/09/2012 : 12:42:58
|
| The back up was done of site our database it is hosted online and I am trying to use the backup to help build reports so I can upload them to our server, So I need to be able to open that database that was backed up in sql server 2008 R2 RTM, can I do that using sql server 2008 R2? Because that is what I have |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48064 Posts |
Posted - 08/09/2012 : 12:50:59
|
quote:
Originally posted by srobison62
The back up was done of site our database it is hosted online and I am trying to use the backup to help build reports so I can upload them to our server, So I need to be able to open that database that was backed up in sql server 2008 R2 RTM, can I do that using sql server 2008 R2? Because that is what I have
not sure if thats correct
as error message clearly suggests like
...That version is incompatible with this server which is running version 10.00.5500
which is actually sql server 2008 sp3 and not R2
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
srobison62
Starting Member
17 Posts |
Posted - 08/09/2012 : 12:59:40
|
| See that is what I didnt understand either, I am clicking microsoft sql server 2008 r2 management studio, but when I try to restore a database it gives me that error. Sorry if I sound clueless, its mostly because I am this is the first time i've ever worked in sql server, I am just trying to get to the point where I can write sql statements against this backup of my database, thanks for the help so far! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48064 Posts |
Posted - 08/09/2012 : 15:11:17
|
quote:
Originally posted by srobison62
See that is what I didnt understand either, I am clicking microsoft sql server 2008 r2 management studio, but when I try to restore a database it gives me that error. Sorry if I sound clueless, its mostly because I am this is the first time i've ever worked in sql server, I am just trying to get to the point where I can write sql statements against this backup of my database, thanks for the help so far!
using sql 2008 r2 management studio doesnot necessarily imply that db is 2008 r2. management studio is just a client tool. you can still install mgmnt studio from 2008 r2 setup and make it connect to sql 2008
so try running
SELECT @@VERSION
and see the output
it should tell you exactly version of db you're actually connecting to
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
srobison62
Starting Member
17 Posts |
Posted - 08/10/2012 : 10:47:43
|
| MICROSOFT sql SERVER 2008(rtm) 10.0.1600.22 SO IF I FIND AN UPDATE FOR THIS ITSHOULD FIX IT? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48064 Posts |
Posted - 08/10/2012 : 10:50:17
|
quote:
Originally posted by srobison62
MICROSOFT sql SERVER 2008(rtm) 10.0.1600.22 SO IF I FIND AN UPDATE FOR THIS ITSHOULD FIX IT?
yep...it should
and as i told before the issue was your client tool (ssms) was 2008 r2 but actual db was still 2008 rtm version 
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
srobison62
Starting Member
17 Posts |
Posted - 08/13/2012 : 09:28:21
|
| Yea it looked like an easy fix thats why I couldn't understand what happened, but once again I did the update and I am getting the same error, its like the DB isn't changing. |
|
|
|
srobison62
Starting Member
17 Posts |
Posted - 08/13/2012 : 09:32:13
|
I used a discovery report and this is what it said:
Microsoft SQL Server 2008 R2 SP2 Setup Discovery Report
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS Database Engine Services 1033 Express Edition 10.0.1600.22 No
Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS SQL Server Replication 1033 Express Edition 10.0.1600.22 No
Microsoft SQL Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Express Edition 10.50.1600.1 No
Microsoft SQL Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER SQL Server Replication 1033 Express Edition 10.50.1600.1 No
Microsoft SQL Server 2008 R2 Management Tools - Basic 1033 Express Edition 10.52.4000.0 No |
|
|
| |
Topic |
|
Getting SQL Server up to date
