How to restore the backup file of the Sql2000 database to Sql2005

P.s. The key lies in
Right-click database a and choose Restore database"
B. The restored database must be different from the original database.
C. Confirm the save path.



[Solution]

If you want to use SQL Server 2000 to successfully restore to SQL Server 2005, you cannot follow the restoration steps in SQL Server 2000. That is, you cannot create a database with the same name as the original database, the correct restoration method is described as follows:

1. Delete the database with the same name as the database to be created during the above operation or restoration, and delete the existing 'cn17006 _ db' database as shown in the figure above;

2. Right-click "database" and choose "restore Database ";

3. In the displayed window, enter the target database, such as CN17006_db, select "source device", and click browse;

4. Click "add", select the backup file of SQL Server 2000, click "OK" to go to the initial window, and select the check box in the "Restore" column before the file;

5. Click "OK" to restore the database.

[Key]
The above content is hard to see. When you use the database backup file of SQL Server 2000 to restore the database of SQL Server 2000 and the database of SQL Server 2005, in SQL 2000, you must create a new database and restore it. In SQL 2005, you must not create a new database to restore it. Another difference is that the name of the database to be created in SQL 2000 is the same as the name of the original database, while the name of the database entered in SQL 2005 can be any name, the name of the database does not need to be the same as that of the original database.

Note:

If the above method still does not work, it may be a problem with the data backed up by the database.

If this error message is displayed

This indicates the path problem. Put the backup file of the database under the corresponding path, for example, under the "c: Program FilesMicrosoft SQL ServerMSSQLdata" file, and re-add the file.