Restore differentil backup to SQL 2000

  •  

    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.

  • Before you restore a diff, you need to restore a full.

  • 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

  • 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

  • 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.

  • 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?

     

  • 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