xoxomos
asked on
Backup SQLServer 2000 Restore To 2008
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.smoEx tended
Additional information system.data.sqlclient.sqle rror: 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?
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.smoEx
Additional information system.data.sqlclient.sqle
Does SQLServer not allow you to take a backup on one server and restore it to a different server?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER