Improve company productivity with a Business Account.Sign Up

x
?
Solved

Restore SQL Server 2005 DB

Posted on 2006-11-26
12
Medium Priority
?
439 Views
Last Modified: 2011-04-14
hi,
   I have sql server 2005 i am trying to restore newer version of sql 2005 database.. and i am getting error.. any suggestion how to avoid version check without updating to newer sql 2005 version?

here is the error.

TITLE: Microsoft SQL Server Management Studio
----------------------------------------

Restore failed for Server 'MYSERVER\SQL2005'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1116.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

----------------------------------------
ADDITIONAL INFORMATION:

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1116.00&LinkId=20476
0
Comment
Question by:frontpor
  • 6
  • 4
10 Comments
 
LVL 29

Expert Comment

by:Nightman
ID: 18014940
You are trying to restore on a CTP version of SQL Server (i.e. prior to RTM - the official release) - RTM was 9.00.1399, SP1 is 9.00.2047.

I would recommend that you get the latest released version of SQL 2005 (SQL Express is downloadable from Microsoft). Actually I would get the latest version and SP1, and install on all your servers.
0
 

Author Comment

by:frontpor
ID: 18015001
Do you mean i have to uninstall my current version of sql 2005 and install sql express?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
LVL 29

Expert Comment

by:Nightman
ID: 18015009
If you have the full version of SQL Server 2005, you can download that and install it. Alternatively, download SP1 and apply that to your version of SQL - this might resolve your problem.
0
 

Author Comment

by:frontpor
ID: 18015031
I have full Microsoft SQL Server Management Studio 9.00.1116.00 Trial Version.. should i go with this link

Service Pack 1
http://www.microsoft.com/downloads/details.aspx?familyid=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=en

OR

Service Pack 1 for SQL Express
http://www.microsoft.com/downloads/details.aspx?familyid=11350B1F-8F44-4DB6-B542-4A4B869C2FF1&displaylang=en
0
 

Author Comment

by:frontpor
ID: 18015039
thanks. i am trying
0
 

Author Comment

by:frontpor
ID: 18016454
I downloaded and tried to install this SP.. but i am getting this.. error

You cannot apply this service pack to a pre-release version of SQL Server 2005. To continue, upgrade to the release version of SQL Server 2005,  and then run setup again.

what should i do now?
0
 
LVL 29

Accepted Solution

by:
Nightman earned 2000 total points
ID: 18017442
Upgrade to the release version of SQL Server. I don't believe that you have any other option. You don't hav to uninstall your existing version - these can run side by side.
0
 
LVL 29

Expert Comment

by:Nightman
ID: 18198083
Hi frontpor

Was I able to assist you? If not, please can you provide some feedback, or have a look at http://www.experts-exchange.com/help.jsp#hs5 for information on closing questions.

Regards
Nightman
0

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

608 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