Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Unanswered: 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.il

  2. #2
    Join Date
    Jul 2002
    Posts
    4
    cant u just copy the dump? locally and then try and restore it?

  3. #3
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73
    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.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    What error/message do you receive when it fails ?

  5. #5
    Join Date
    Jun 2002
    Location
    USA
    Posts
    21
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •