Restore backup data to the database

1. First, create a temporary database A1.
2. Right-click Database A1 and choose all tasks> Restore database.
3. In the "Restore database" window, select "Slave Device ".
4. Click "select device ".
5. Click "add ".
6. Select the database file to be restored from the file name, such as A1.BAK.
7. Click "OK" and return to the "Restore database" window.
8. Click the "options" tab to go to option settings.
9. Select "Force restore on existing database ".
10. Change "move to physical file name" to "c: \ a1.ldf" and "c: \ a1.mdf ".
11. Click OK to import the data in the backup file to the temporary database A1.
12. Now, you can import data from A1.