Activity overview
Latest activity by SethP
I'm having exactly the same problem. Here's what I'm doing:
- on the sql 2000 server, I do a standard backup to a sqb file
- I copy that file to the local drive on the sql 2005 server (they are completely different computers)
- I open sql backup on the 2005 computer, and click restore
- I select the file from the 2000 server
- I select either an existing or new database, it doesn't matter
- restore fails every time. It says, "Use WITH MOVE to identify a valid location for the file." There are no permission issues of any kind.
I did a quick backup from the 2005 db and a restore into a new db on the same server with no problems.
I am unable to restore any backups from sql 2000 to 2005.
Thank you.
Seth / comments
I'm having exactly the same problem. Here's what I'm doing:
- on the sql 2000 server, I do a standard backup to a sqb file
- I copy that file to the local drive on the sql 2005 server (they are co...