April 4, 2006 at 4:51 am
Hi,
Actually I had restore the full backup 1st then the latest differential backup i was trying to restore while i got the error
Server: Msg 3136, Level 16, State 1, Line 2
Cannot apply the backup on device 'D:\BACKUP\IMCL_NW\IMCL_DIF.BAK' to database 'IMCL'.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Rgds
Jey
Guys thanks for the inputs.
April 4, 2006 at 9:15 am
Before you restore a diff, you need to restore a full.
April 4, 2006 at 10:54 am
We need more information from you.
1. As Steve asked, did you first restore the FULL backup using WITH NORECOVERY?
2. Are you trying to restore the DIFFERENTIAL right after you already restored it?
3. Is this the same differential, or are you trying to restore a second differential (Restore Full, Differential1, Differential2)? BTW-if this is what you are trying to do, you can't do it. You can only restore ONE differential and normally it's the most recent one.
4. what is the exact error message? (You should be able to find it in 1. the SQL Server Error Logs or 2. the Windows Event Viewer Logs).
-SQLBill
April 4, 2006 at 1:12 pm
Also sometimes the backup is from another server with different drive structure and we have to correct the drive letter or path in the Physical Path for the files. The error message in this case concludes with "Use With Move Option..." advice wich translates to User Interface as "correct the file path"
Regards,Yelena Varsha
April 4, 2006 at 10:11 pm
Hi,
Actually I had restore the full backup 1st then the latest differential backup i was trying to restore while i got the error
Server: Msg 3136, Level 16, State 1, Line 2
Cannot apply the backup on device 'D:\BACKUP\IMCL_NW\IMCL_DIF.BAK' to database 'IMCL'.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Rgds
Jey
Guys thanks for the inputs.
April 5, 2006 at 12:14 pm
It might sound strange, but did you perform a Diff backup of a physical Database...
If yes, then can it be a wrong ( with broken LSNs) Diff backup you are trying to apply?
April 6, 2006 at 8:23 am
When you restored the full database did you use the WITH NORECOVERY option?
RESTORE DATABASE dbname
FROM.......
WITH NORECOVERY
If not, then you cannot restore any more files to that database.
-SQLBill
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply