Hi,

i have been trying to restore a backup file that i copied from a server that run MSDE to another server that runs Microsoft SQL Server 2005, am actually trying to upgrade from MSDE to MS SQL Server 2005, i have also tried the script option you suggested but am still having the problem.

The error message is: Msg 314, Level 16, State 4, Line 1

The backup set holds a backup of a database other than the existing 'XXXXX' database

Msg 3013, Level 16, State 1, Line 1

RESt

ORE DATABASE is terminating abnormally.

Can somebody pls help?