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\new\DB_ full.BAK'

RESTORE HEADERONLY FROM DISK = 'D:\Backup\new\DB_ ull.BAK'

RESTORE LABELONLY FROM DISK = 'D:\Backup\new\Test_full.BAK'

RESTORE VERIFYONLY FROM DISK = 'D:\Backup\new\Test_full.BAK'

Also The full back up restoration works fine:

RESTORE DATABASE Test3 FROM DISK = 'D:\Backup\new\Test_full.BAK'

WITH MOVE 'Test2_Data' TO 'F:\MSSQL2K\MSSQL\data\Test2Net_Data.MDF',

MOVE 'Test2_Log' TO 'F:\MSSQL2K\MSSQL\data\Test2Net_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\new\test2_Diff1.bak'

WITH NORECOVERY

GO

Msg 3136, Level 16, State 0, Line 1

Cannot apply the backup on device 'D:\Backup\new\test2_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 !

is the differential backup appended or overwritten ? ? ?........if appended choose the exact differential backup and try to restore....also try using GUI and see........|||Differential backup is a separate file...

Different Database

I have two databases one is active the other is HIstory data. I need a command button or link or some sort of interface to the other database. Can that be done with a trigger or stored procedure?? How would I go about doing that in (has an access interface, sql engine)You would do it the same way you build an interface to the production system. I guess I'm confused about what you are asking.