Solved

Restoe error

Posted on 2006-11-08
3
339 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
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
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…
Viewers will learn how the fundamental information of how to create a table.

757 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now