Import an existing database from a SQL Server backup file

SQL Server itself has data import operations. However, if you want to import data from a backed-up file, you need to do another operation. Here is an example to illustrate.

There is already a DOE database on the SQL Server server, and there is a lot of data in it, and you are ready to import additional data from another backup file A1.bak (not the backup file for the DOE database) (that is, add some data tables to the DOE after the import, and the data is recorded in the table) And keep the original DOE data unchanged.

1. First, create a new temporary database A1 in SQL Enterprise Manager.

2, right click A1 Database, select: All Tasks-> restore the database.

3. In the "Restore Database" window, select: "From Device."

4, click "Select Equipment".

5, click "Add".

6, from the filename to select the database file to restore, such as A1.bak.

7, click "OK" and return to the "Restore Database" window.

8, click the "Options" card, enter the option settings.

9. Hook selection: "Force restore on existing database".

10, modify "Move to physical file name" as: "C:a1.ldf", "C:a1.mdf".

11, click OK, you can import the data from the backup file into the staging database A1.

12. At this point, you can import data from A1 into another database that you really want to import, such as the DOE database.

(The following data import operation is a general data import export operation for SQL2000 Enterprise Manager.) )

13. In SQL Enterprise Manager, select the "DOE" database.

14, right click Doe Database, select: All Tasks-> import data.

15. In the DTS Import/Export Wizard window, in select data source, the data source selects the staging database A1 that just created and imported the data. Click Next.

16, in the "choice of purpose", the system has been default to the DOE database.

17, continuously click "Next" until completed.

With the above operation, you have successfully imported the data from the backup file A1.bak into the DOE database, and the original data of the DOE database is unchanged.

At this point, you can delete the temporary database A1.