Restoring a database to another server prompts that the database backup in the backup set is different from the existing database.

When SQL Server 2005 is used to restore a database, unlike 2000, the database and files are distinguished very carefully and unified as files, which makes the restored database file. Bak. During the operation, you must note that in the remarks menu, select "backup file" in the drop-down box, and then "backup database file" will be displayed. Select-OK:

The most important thing is to select "Overwrite existing database" in the "options". Otherwise, the "backup database in the backup set and existing database" problem will occur.

The solution is simple, but I don't know how to do it when I encounter it .~~~ Pai_^