MS SQL 2005 Restore issue

I have a situation with a Database that I need to restore to a temp database.
The issue I have is that I did a full backup  using Symantec Backup Exec  to tape and I have differentials backups to disk since the last full backup.
I restored the full from tape to a temp DB, but when I try to restore the differential backup I get an error.

Msg 3219, Level 16, State 3, Line 1
The file or filegroup "<originalDB>_log" cannot be selected for this operation.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Is there a way that I can get this to work?
LVL 25
yo_beeDirector of Information TechnologyAsked:
Who is Participating?
 
EvilPostItConnect With a Mentor Commented:
If you are doing this from the GUI then will need to ensure that you are restoring the database with NORECOVERY, this will allow you to restore more backups afterwards.

Please see attatched screeenshot

NORECOVERY SETTING
0
 
gothamiteCommented:
Looks like you might be trying to use a restore database command to restore a transaction log file. If the ..._log file is in fact a valid transaction log backup you should be able to restore it with RESTORE LOG command.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
is that temp database in recovery mode ?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
yo_beeDirector of Information TechnologyAuthor Commented:
recovery mode is FULL
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
i mean the database state, did you restore it as in "recovery" or "norecovery"
 
0
 
yo_beeDirector of Information TechnologyAuthor Commented:
thats a good question.  I do not remember.
What should I do?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
can you see the tables in the database ? in that case try restoring the database with 'recovery' option and try applying the logs
0
 
yo_beeDirector of Information TechnologyAuthor Commented:
I have a differential and do not have a trn backup that covers the window needed. If i had the trn backups I think i would be ok
0
 
yo_beeDirector of Information TechnologyAuthor Commented:
I tried what you suggested and received this error when trying to apply the Diff.bak
DiffRestoreError..JPG
0
 
yo_beeDirector of Information TechnologyAuthor Commented:
This was very straight forward.
Thanks for the help.
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.