Solved

Restore SQL Server 2005 DB

Posted on 2006-11-26
12
424 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
12 Comments
 
LVL 29

Expert Comment

by:Nightman
Comment Utility
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
 
LVL 29

Expert Comment

by:Nightman
Comment Utility
0
 

Author Comment

by:frontpor
Comment Utility
Do you mean i have to uninstall my current version of sql 2005 and install sql express?
0
 
LVL 29

Expert Comment

by:Nightman
Comment Utility
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
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 29

Expert Comment

by:Nightman
Comment Utility
0
 

Author Comment

by:frontpor
Comment Utility
thanks. i am trying
0
 

Author Comment

by:frontpor
Comment Utility
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 500 total points
Comment Utility
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
Comment Utility
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
How to query date ranges with SQL 6 22
MS SQL Pagination for Complex Query 5 31
BULK INSERT most recent CSV 19 17
Azure SQL DB? 3 12
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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.
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

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now