Getting SQL Server up to date - 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 Programming

Getting SQL Server up to date

Author

Topic

srobison62
Starting Member

17 Posts

Posted - 2012-08-07 : 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

52326 Posts

Posted - 2012-08-07 : 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 - 2012-08-07 : 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

52326 Posts

Posted - 2012-08-07 : 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 - 2012-08-07 : 10:15:40

No I cannot find SQL in the services list

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-07 : 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 - 2012-08-07 : 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

52326 Posts

Posted - 2012-08-07 : 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 - 2012-08-09 : 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

52326 Posts

Posted - 2012-08-09 : 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 - 2012-08-09 : 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

52326 Posts

Posted - 2012-08-09 : 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 - 2012-08-09 : 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

52326 Posts

Posted - 2012-08-09 : 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 - 2012-08-10 : 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

52326 Posts

Posted - 2012-08-10 : 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 - 2012-08-13 : 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 - 2012-08-13 : 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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources