[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question
[x]
Attachment Details

sql server incompatibility

Asked by palserv in MS SQL Server, SQL Server 2005

Tags: sql server 2005, sql server express

Hi,
i have a database worked on sql server 2005 express edition, the size of this database exceeds
 4 giga. there i found myself forced to use sql server enterprise edition.
In restore process. i faced the incompatibility problem explained in this error message. :

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

Restore failed for Server 'DBSERVER'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1187.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.3042. That version is incompatible with this server, which is running version 9.00.1187. 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.1187.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

i need to transfer my database to sql server 2005 enterprise edition
thanks,
[+][-]10/11/09 02:05 AM, ID: 25545297Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/11/09 05:00 AM, ID: 25545645Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/11/09 05:39 AM, ID: 25545724Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/03/09 02:10 PM, ID: 25734371Administrative Comment

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 30-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625