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.0
0&EvtSrc=M
icrosoft.S
qlServer.M
anagement.
Smo.Except
ionTemplat
es.FailedO
perationEx
ceptionTex
t&EvtID=Re
store+Serv
er&LinkId=
20476
--------------------------
----
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlE
rror: 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.0
0&LinkId=2
0476
--------------------------
----
BUTTONS:
OK
--------------------------
----
i need to transfer my database to sql server 2005 enterprise edition
thanks,