Solved

Restoe error

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

717 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