Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tal_olier
Starting Member
13 Posts |
 Posted - 2002-08-28 : 03:38:28
|
| 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 Olierotal@mercury.co.il |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-08-28 : 03:53:13
|
| What messages are you getting ? I've sucessfully restored a 30 GB database across a network (it's not fun, but it works...)Are you having network connectivity problems, do you have enough space on you target machine,... There are so many posibilities. Give us more info regarding the environment and the actual error'sJust noticing the last line of you message... if you can't map to the drive, your OS won't let you get to it, so you can't see it from SQL, so you won't be able to restore (afaik). Create a share on the source machine, grant EVERYBODY ( or more ideally your userid) read access. Then map the drive and restore. If you are going to continue to restore from that machine, consider setting up a properly controlled, secure environment , or else (if this was an ad hoc), then remove the share after the restore...HTHEdited by - wanderer on 08/28/2002 03:56:50 |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-28 : 14:54:36
|
| 1)Make sure SQL Service is running under a domain account with appropriate access to the network share.2)Use Query AnalyzerRESTORE DATABASE pubs FROM DISK='\\server\share\pubs.bak'HTHJasper Smith |
|
|
|
|
|
|
Restore db from a network drive