Restoe error

DB is in D: and the back up file is in E:

I am trying to do a point-in-tim recovery.
When I add a fullbackup file and transactionlog file in Restore Database window, I get the volumn on device 'E:\backup\finace_a\finace_apps_backup_200611080201.bak' is not part of a multiple family media set.backup with format can be used to form a new media set. RESTORE HEDERONLY is terminating abnormally..

What mai doing wrong?
jung1975Asked:
Who is Participating?
 
SireesConnect With a Mentor Commented:
It sounds from your description and the error message as if you might be attempting to restore the full backup and the log backup in one command.  If that's the case, this is your problem.

You need to restore the full backup first, WITH NORECOVERY, and then restore transaction log backups one by one in order, specifying WITH NORECOVERY until you've got them all applied.  At that point you can restore with recovery, and you're done
0
 
jung1975Author Commented:
I was trying to do it thru the Restore Database window..
in the wondow, I can select the back up sets to restore:I select both .bak and trn file

Is your solution can be apply only in QA? can you show me the step by step instruction?

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.