I have some doubt in my mind related to restoring database in SQL Server 2005.Infact,these are doubts but the pre-requisite you need to complete.
1. Have u tried WITH REPLACE clause in your RESTORE DATABASE command? If not, then use it. If you still get errors, provide me with the following information:
The output of the following command:
2. From the Target Server (on which you want to restore the database), send the output commands as given below:
RESTORE FILELISTONLY FROM YourDBBackupFile_name.BAK
NB: and for that you need to know the target database files
USE DBName — (Existing target database name)
SELECT name, filename FROM SYSFILES
3. Is the existing target database OR a copy of the database backup you want to restore or is it some different database altogether?
Waiting for your reply.