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?