Restoring a database in SQL2005 1

[tbode2006]

I have SQL2005 express running in a VM session. My client has sent me a backup of his database. I copy the backup to a local directory c:\databases. Right-clicking on the +Databases branch brings up the Restore Database dialog UI. I specify the source of the backup as FROM DEVICE, navigate to by backup file and ADD it. I click on the restore check box and type ine a new database name for the RESTORE TO option.

My restore fails with the following message:
Restore failed for Server 'VIRTUAL-BASE'. (Microsoft.SqlServer.Smo)
Additional Information:
System.Client.SqlClientSqlError: Directory lookup for the file "S:\SQL\Data\dbPaintKR.mdf" failed with the operating system error 3(The system cannot find the path specified.) (Microsoft.SqlServer.Smo)

Online help is of no use for this. What am I missing and how do I proceed?

 

[drtree]

Hey,

It looks like it's looking for a directory that doesn't exist. When you're going through the restore process, you should be able to specify the restore path (which is what you'll want to do in this case).

HTH,

Dr Tree

 

[tbode2006]

I tried putting the backup file on another system and mapping drive letter S: to that path but the restore UI does not appear to allow me to point to a location other that C:

 

[Crowley16]

put the backup in the virtual machine, and make sure the restore path is in the virtual machine as well...

--------------------
Procrastinate Now!

 

[tbode2006]

Got it. Had to use the OPTIONS section to redirect the restored files to the local drive.