Sql2000 the method of restoring the backup file of the database to Sql2005 _mssql

Core steps:

Right-click the database Select Restore database directly in SQL Server 2005.

Detailed content:

To restore a database in SQL Server 2005 with a database backup of SQL Server 2000

You now have a database backup file in SQL Server 2000 (if the backup file does not have a suffix *.bak or *.trn, append the appropriate suffix name) to restore the file to SQL Server 2005 and suddenly make an error when restoring, for which you searched for articles on the web. Jin Qing column has a "sql2005 backup restore Problem " explained, but the personal feeling is not very detailed, The analysis and solution are explained in detail.
Simple Review
If we have a database backup file for SQL Server 2000, what do we do to restore to another SQL Server 2000 database?
1, on the destination database server, open SQL Server 2000 's Enterprise Manager and create a new database with the same name as Yuanku;
2, right-click to select the newly created database, locate and select Restore Database, then select from device in subsequent window;
3, add SQL Server 2000 database backup files and check to overwrite the original database, click OK, restore success!
The above description is a simple review of the process of restoring a database in SQL Server 2000, although the narrative steps are not detailed, but the general steps can be a bit of a problem! Please look down ...
Restore SQL Server 2005
to review the database restore steps in SQL Server 2000, do you want to restore SQL Server 2000 database backup to SQL Server 2005? And so I did it:
1, in the target database server, open SQL Server Management Studio, after the successful login, the new database with the same name Yuanku;
2, right-click to select the new database, select Restore under Tasks, then select Source device in the next window,
3, add SQL Server 2000 database backup file (the backup file here must have added a suffix name), tick the file in the list and click OK.
4, the prompt error message is as follows:
title: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server "* * *". (MICROSOFT.SQLSERVER.SMO)

For help information, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc= microsoft.sqlserver.management.smo.exceptiontemplates.failedoperationexceptiontext&evtid= Restore +server& linkid=20476

------------------------------
Additional Information:

System.Data.SqlClient.SqlError: Database backups in the backup set are different from the existing ' * * * ' databases. (MICROSOFT.SQLSERVER.SMO)

For help information, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

------------------------------
Button:

Are you sure
------------------------------
The drawings are as follows:

Detailed error information is shown below:

"Resolve Steps"
After reading theSQL2005 backup restore problem in Jin Qing's column , I know that to successfully restore SQL Server 2000 to SQL Server 2005 does not follow the restore steps in SQL Server 2000. That is, you cannot create a new database with the same name as Yuanku, and the correct restore method is described as follows:
1, delete the above operation of the new database or restore the database name to start the same database name, combined with the above image delete existing ' cn17006_db ' database;
2, right click "Database" select "Restore Database";

3, in the appearance of the window to enter the target database, such as input cn17006_db, and select the "Source Device", click the browse button;

4, click the "Add" button, select the SQL Server 2000 backup files, click the "OK" button to the initial window, check the file before the "Restore" column checkbox;

5, click "OK" button, the database restore success.

"The Key"
This doesn't look bad. When you restore a SQL Server 2000 database and restore a database of SQL Server 2005 by using a SQL Server 2000 database backup file, the key is that you must create a new database and restore it at SQL 2000, while in SQL When you are 2005, you must not create a new database to restore it. Another difference is that when SQL 2000 is created, the database name is the same as the original library name, and the database name entered at SQL 2005 can be any name, not necessarily the same as the original library name.

Attention:

If the above method is still not possible is the database backup data problem.

If you receive this error prompt screen

Description is the problem of the path, put the backup file of the database under the corresponding path, as above is "C:\Program Files\Microsoft SQL Server\mssql\data\" file, add the file again.