Differential Backup File Fails To Restore.

We are doing the following steps:-

1. Weekly Full Bckup

2.Daily Differential backup

3.hr Log back up

The following command works fine for all the Backups. it means backup file is fine.

RESTORE FILELISTONLY from DISK = 'D:Backup
ewDB_ full.BAK'

RESTORE HEADERONLY FROM DISK = 'D:Backup
ewDB_ ull.BAK'

RESTORE LABELONLY FROM DISK = 'D:Backup
ewTest_full.BAK'

RESTORE VERIFYONLY FROM DISK = 'D:Backup
ewTest_full.BAK'



Also The full back up restoration works fine:

RESTORE DATABASE Test3 FROM DISK = 'D:Backup
ewTest_full.BAK'

WITH MOVE 'Test2_Data' TO 'F:MSSQL2KMSSQLdataTest2Net_Data.MDF',

MOVE 'Test2_Log' TO 'F:MSSQL2KMSSQLdataTest2Net_Log.LDF',

NORECOVERY

GO

/* RESULT :

Processed 1032 pages for database 'Test3', file 'test2_Data' on file 1.

Processed 1 pages for database 'Test3', file 'test2_Log' on file 1.

RESTORE DATABASE successfully processed 1033 pages in 1.907 seconds (4.433 MB/sec).

*/

But While restoring the Differential file it throws error:

RESTORE DATABASE Test3 from DISK = 'D:Backup
ew est2_Diff1.bak'

WITH NORECOVERY

GO



Msg 3136, Level 16, State 0, Line 1

Cannot apply the backup on device 'D:Backup
ew est2_Diff1.bak' to database 'Test3'.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

I checked the SQL Server Log no error msg corresponding Differential backup restore.



I don't know how to proceed further.Can any one guide me how to over come this..



Thanks !