MS SQL 2005 Restore issue
Posted on 2010-11-11
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?