Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 984
  • Last Modified:

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?
0
yo_bee
Asked:
yo_bee
  • 5
  • 3
  • 2
  • +1
1 Solution
 
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
 
yo_beeDirector of ITAuthor Commented:
recovery mode is FULL
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
Aneesh RetnakaranDatabase AdministratorCommented:
i mean the database state, did you restore it as in "recovery" or "norecovery"
 
0
 
yo_beeDirector of ITAuthor 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 ITAuthor 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
 
EvilPostItCommented:
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
 
yo_beeDirector of ITAuthor Commented:
I tried what you suggested and received this error when trying to apply the Diff.bak
DiffRestoreError..JPG
0
 
yo_beeDirector of ITAuthor Commented:
This was very straight forward.
Thanks for the help.
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.

  • 5
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now