Step 1: For restoring existing backup to database right click on database and go to tasks and select restore. A window with two tabs viz. General and Options will be shown.
Step 2: For General tab select following options.
- Destination for Restore:
- To Database: Sample
- To a Point in time: Most Recent possible.
- Source for restore:
- From Device: Select backup file as shown below.
Step 2: For Options tab select following options
- Restore Options:Overwrite the existing database (WITH REPLACE)
- Prompt before restoring each backup
- Recovery State
- Leave the database ready to use by rolling back uncommitted transactions. Additional Logs cannot be restored(RESTORE WITH RECOVERY)
No comments:
Post a Comment