Restore SQL Server 2005 DB

Posted on 2006-11-26
Medium Priority
Last Modified: 2011-04-14
   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


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
Question by:frontpor
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
LVL 29

Expert Comment

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.

Author Comment

ID: 18015001
Do you mean i have to uninstall my current version of sql 2005 and install sql express?
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

LVL 29

Expert Comment

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.

Author Comment

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


Service Pack 1 for SQL Express

Author Comment

ID: 18015039
thanks. i am trying

Author Comment

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?
LVL 29

Accepted Solution

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.
LVL 29

Expert Comment

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.


Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

777 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