use master;

go

restore database new_loc_testdb

from disk = '\\backup_dir\full\prod_full_20140803_233000.bak'

with

--replace

checksum

,move 'prod01' to 'e:\temp_restore\data01.mdf'

,move 'prod02' to 'e:\temp_restore\data02.ndf'

,move 'prod03' to 'e:\temp_restore\data03.ndf'

,move 'prod04' to 'e:\temp_restore\data04.ndf'

,move 'prod_log' to 'e:\temp_restore\testlog.ldf'

,norecovery

go

restore database new_loc_testdb

from disk = '\\backup_dir\diff\prod_diff_20140806_233000.bak'

with

checksum

,move 'prod01' to 'e:\temp_restore\data01.mdf'

,move 'prod02' to 'e:\temp_restore\data02.ndf'

,move 'prod03' to 'e:\temp_restore\data03.ndf'

,move 'prod04' to 'e:\temp_restore\data04.ndf'

,move 'prod_log' to 'e:\temp_restore\testlog.ldf'

,recovery;

[font="Courier New"]Processed 177488 pages for database 'new_loc_testdb', file 'prod01' on file 1.

Processed 39448 pages for database 'new_loc_testdb', file 'prod02' on file 1.

Processed 41664 pages for database 'new_loc_testdb', file 'prod03' on file 1.

Processed 26144 pages for database 'new_loc_testdb', file 'prod04' on file 1.

Processed 3 pages for database 'new_loc_testdb', file 'prod_log' on file 1.

RESTORE DATABASE successfully processed 284747 pages in 13.255 seconds (167.829 MB/sec).

Msg 3136, Level 16, State 1, Line 13

This differential backup cannot be restored because the database has not been restored to the correct earlier state.

Msg 3013, Level 16, State 1, Line 13

RESTORE DATABASE is terminating abnormally.[/font]