?
Solved

Restoe error

Posted on 2006-11-08
3
Medium Priority
?
349 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
2 Comments
 
LVL 20

Accepted Solution

by:
Sirees earned 2000 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 recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

840 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