SimonEireconsulting
IS-IT--Management
Hi,
Anyone know how I can move a database from SQL Server 2003 to another server with SQL Server 2005 - when I try and do a restore with the option Force Overwrite (as I did from one server to another using the SQL Server 2003 on bother servers and it worked) I get the message:
The backup set holds a backup of a database other than the existing 'XXX' database.
where XXX is tha name of my database
Anyone know how I can move a database from SQL Server 2003 to another server with SQL Server 2005 - when I try and do a restore with the option Force Overwrite (as I did from one server to another using the SQL Server 2003 on bother servers and it worked) I get the message:
The backup set holds a backup of a database other than the existing 'XXX' database.
where XXX is tha name of my database