1. Perform complete recovery Enterprise Manager - Right-click "Database" - All Tasks - Restore Database - "Restore to Database Library" Enter the restored database name, set to: Test - Restore Select "From Device" - Select device - Add - Add your backup file - OK, return to the database restore interface - "Restore Backup Set", select "Database - Full" - Option - Transfer "Move to physical files "The physical file name in the name is modified for the file name to be stored for your data file - if the database to be restored already exists, select" Forced Restore on the existing database "-" Restore Completion Status ", select" to make the database No longer run, but can restore other transaction logs "- determine
- Or with SQL statement: restore database database from disk = 'c: / Your full backup file name' with recovery
2. Differentially Restore Enterprise Manager - Right-click "Database" - All Tasks - Restore Database - "Restore to Database Library" Select Database Name: Test - Restore Select "From Device" - Select Device - Add - Add your backup file - OK, return to the database restore interface - "Restore Backup Set", select "Database - Difference" - "Restore Completion Status", select "Enable the database to continue running, but Unable to restore other transaction logs "- OK
- Or with SQL statement: Restore Database Database from Disk = 'C: / Your Difference Backup File Name' with Norecovery
