Backing up and restoring SQL Server databases is a broad and complex subject and there are numerous ways to do it. Please treat the below instructions as an example and refer to Books Online for the detailed explanation. Right-click the "Databases" folder and select "Restore Database..." option In the "Restore Database" dialog box, on "General" page, in the "To Database" text field either type a new database name (if you are restoring to a new database) or select the existing database from the drop-down menu. Under the "Source for restore" section select "From device" radio button In the "Specify Backup" dialog box select "File" from the "Backup Media" drop-down menu Click "Add" button, locate your backup file, and click "OK" and again "OK" buttons. In the "Select the backup sets to restore" select the check-box next to the backup set you just added Optionally, you can go to "Options" page and select the options you find appropriate Click "OK" button to initiate the restoration process
