1. Complete recovery
Enterprise Manager -- Right-click "Database" -- all tasks -- Restore database
-- Enter the restored database name in "Restore to Database" and set it to test.
-- Restore select "from device" -- select device -- add your backup file
-- OK. Return to the database restoration page.
-- "Restore backup set", select "database -- full"
-- Option -- change the physical file name in "move to physical file name" to the name of the data file to be stored.
-- If the database to be restored already exists, select "Force restore on the existing database"
-- "Recovery completed", select "make the database no longer run, but can restore other transaction logs"
-- OK
-- Or use an SQL statement:
Restore database from disk = 'C:/your full Backup Filename 'with recovery
2. Restore the difference
Enterprise Manager -- Right-click "Database" -- all tasks -- Restore database
-- In "Restore to Database", select database name: test.
-- Restore select "from device" -- select device -- add your backup file
-- OK. Return to the database restoration page.
-- "Restore backup set", select "database -- difference"
-- "Restore completed", select "enable database to continue running, but cannot restore other transaction logs"
-- OK
-- Or use an SQL statement:
Restore database from disk = 'C:/your differential Backup Filename 'with norecovery