SQL Server 2005 restores the database file in the new library. The database backup in the backup set is different from the existing ' JM2012 ' database. "There are several possible errors:
First, overwrite the original database is not selected when you restore the new database.
WORKAROUND: Options-> Restore Options (Restore options)-> overwrite existing databases (Overwrite the existing database)
Second, the new database file is different from restoring the database filename.
WORKAROUND: Delete the newly created database A, right-click on the database button-Restore the database. Out of the dialog box to find the backup file A.bak, the target Database drop-down box automatically appears in the backup file in the same database name, select it, restore, successful operation.
third, the database backup is not a full backup.
You need to determine if it is a full backup. If you back up your backup files to a new library, you must use a full backup instead of a differential backup file.