Restore db from a network drive

Hello
I'm trying to restore db from a network drive and for some reason it fails.

Is there a flag I can light or another workaround I can use in order to make it succeed ?

I've tried mapping the drive but no success there.

Regards,

Tal Olier
otal@.mercury.co.ilcant u just copy the dump? locally and then try and restore it?|||Originally posted by iis5_rulez
cant u just copy the dump? locally and then try and restore it?

I have to add storage on the ms-sql machine ...
Trying to find a workaround for the above.|||What error/message do you receive when it fails ?|||Hi,

Follow these steps, you will sure get this done.

1. Share the directory where the backup file is.

2. In the machine where you are going to restore, map the network drive. In Explorer , goto "Tools" then "Map Network Drive". If you are not able to map the drive, (which means your system cannot talk to that share ) then you can stop at this point and solve this issue first.
This is just a check whether you can talk to the backup file share from your machine. If yes, then proceed to next step.

3. Right click the database -> All Tasks -> Restore Database.

4. select "from Device" -> Select DEvices -> Add .

5. In the file name, give the name like this Example ,
\\Servername\share\pubs.bak

6. GOto "Options" ->Select "Force" and check the "Move to file name" path is as per the resorting database. If this is different, it will show error. If the file .mdf and .ldf paths are correct , then you are all set. You will get the message "Databas is Restored"

Hope this helps. If you please give correct error message you get.

Appreciate a reply.

Have Fun:)
Varad01