SQL Server 2005 "database backups in a backup set are different from existing databases" workaround _mssql2005

I used to use SQL Server2000, and now it's so tight with the trend, and I need to use SQL Server2005 to use it in my current project. For SQL Server 2005, there are several places to pay attention to, for example, when restoring a database, unlike 2000 inside the database and file to distinguish between the very thin, uniform is a file, which makes the restored database file. Bak. Then you want to restore 2000 of the database (back up the database files, no prefix name), you need to manually select.

Select all files in the Drop-down box, and then the backup database file is displayed, select-OK

The main thing is to select Overwrite existing database in options, or you will receive a "database backup in the backup set and an existing database" problem.