could not restore db to another different computer
-
Hello everyone.
I am new to SQL Server 2000.
I just back up a database on computer A using the Wizard.
I transfer the file to computer B.
I want to restore the database to computer B and I get the following error using the wizard:
ODBC SQLState: 42000
Device Activation Error: The physical file name 'f:\blah\blah\xxx.MDF' maybe incorrect. File 'filename' cannot be restored to 'f:\blah\blah\xxx.MDF'. Use WITH MOVE to identify a valid location for the file.
Well, in computer B, there is no drive f.
I know I am not doing it right and please tell me what I did wrong. I appreciate your help.
-
I recently came across this error myself and if I remember correctly, all I did was change the path and filename...so in your restore...try and change the "f:\blah\blah\xxx.MDF" to the actual path/location of the .mdf file and see if that fixes it...
**ASCII stupid question, get a stupid ANSI !!!** -
OK, I go to restore database, then I click "From Device", I choose "Select Device", click on "Disk" and I go to the file that is the backup and click OK and I got the mention error on my first post. So I did choose the correct file. But it cant restore to another computer. Still no clue.
-
I got it working!
On computer B, I have to create a database first. Then I do the import. Now I got the replica of the computer A. Learn new things everyday.
-
I didn't realize you hadn't created a database first - what were you trying to restore the backup to ?!?!
Glad that you got it working!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply