Solved

Restoe error

Posted on 2006-11-08
3
343 Views
Last Modified: 2008-01-09
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?
0
Comment
Question by:jung1975
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 20

Accepted Solution

by:
Sirees earned 500 total points
ID: 17900334
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
 

Author Comment

by:jung1975
ID: 17900834
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question