Right i need to remove databases from our old SQL2000 server to our new 2008R2 server
i backed up one of the databases (on 2000), then recreated a db on the R2 server (calling the db the same name) then tried to restore to the new server.
when i did i received the below error
Restore failed for server 'SQLR2'. (microsoft.SqlServer.SmoExtended)
System.Data.SqlClient. SqlError: The backup set holds a backup of a database other than the existing 'clockings' database. (Microsoft.SqlServer.Smo)
anyone any ideas?