Trying to back up a database on SQLServer 2000 then restore to 2008 Express.
I see two files generated Training and Security Tables.BAK. I put them on the Windows 7 2008 Express machine create and new empty database called Training, right click on Training -> Tasks->Restore database. To database Training_> From Device. I add the Training and SecurityTables.BAK.
I get "Restore failed for server 'zz\sqlexpress' (Microsoft.sqlserver.smoExtended
Additional information system.data.sqlclient.sqlerror: the backup set holds a backup of a database other than the existing training database.
Does SQLServer not allow you to take a backup on one server and restore it to a different server?