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 |
|
sorynels
Starting Member
3 Posts |
 Posted - 2004-09-02 : 10:21:40
|
I want to backup a database to a computer from my network but it doesn't work.BACKUP DATABASE xxxx TO DISK = '\\computername(or ip address)\guest\xxxx.bak' WITH INITThe error:Cannot open backup device '\\computername(or ip address)\guest\xxxx.bak'. Device error or device off-line. See the SQL Server error log for more details.What can I say is: That computer work fine and network the same.Are there others configurations to be made? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-02 : 10:25:09
|
| Check to make sure you can access the network path with the login you are using to run the backup... My guess is it doesn't have rights to that path... |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-09-02 : 10:25:18
|
| Back the file up locally first then copy it across.-------Moo. :) |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-02 : 23:45:04
|
| I just recently explored this option.I found out you have to access the destination from the source. From there you can supply the login information. But be careful with this option, this setup will have to be repeated if you restarted or log off either of the two.Or you should include the account logon to the source machine as member of the administrator group on the destination machine. |
|
|
|
sorynels
Starting Member
3 Posts |
Posted - 2004-09-03 : 04:19:51
|
| I use this:EXEC sp_addumpdevice 'disk', 'baklacristina', '\\cristinac\Magazie\baklacristina.bak'and for connection - this .batnet use r: \\cristinac\magazie /user:corporate\xxx.xxx b0ggf4nisql -U sa -P -S bogdan -Q "backup database bogdancteste22004 to baklacristina with init"net use r: /dand i've got the same error:deice error or device is off-linelocal backup works fine and the same for share So, if you have a complete solution - please let me find out! TKS! |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-03 : 04:24:33
|
| The sa account will not have permissions to the network path as it is a sql login and not a windows login... |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-03 : 05:11:24
|
I tried your connection info,i removed the r: and it worked fine. I'm not familiar with this, what's it supposed to do?quote:
Originally posted by sorynels
I use this:EXEC sp_addumpdevice 'disk', 'baklacristina', '\\cristinac\Magazie\baklacristina.bak'and for connection - this .batnet use r: \\cristinac\magazie /user:corporate\xxx.xxx b0ggf4n
|
|
|
|
|
|
|
Network SQL Backup