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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-16 : 06:58:04
|
| Roxolana writes "Hello,I am having problems backing up a database to a network drive. I tried both through Enterprise Manager and through Query Analyzer:BACKUP DATABASE foo TO DISK = '\\myserver\users\roxolana\foo.bak' WITH INITWe always receive this errorServer: Msg 3201, Level 16, State 1, Line 1Cannot open backup device '\\myserver\users\roxolana\foo.bak'. Device error or device off-line. See the SQL Server error log for more details.Server: Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.The machines are all on the domain and the user has enough writes to perform a backup and full conrol for the network location.I am not sure if there any settings on the server preventing backup to the network location.Thank you in advance for any insights.Roxolana" |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-12-16 : 07:46:34
|
| Back up on network is not a good option. Take the backup on local drive and copy it on the network.------------------------I think, therefore I am |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-17 : 04:34:47
|
| if you're still planning to do network backup,you must open the line between source and destination machine,open the folder in destination machine from source machine. once established, try the backup again--------------------keeping it simple... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-17 : 15:19:02
|
| And the path and filename must be valid from the database server and not from the client machine. So it runs from the server.Tara |
|
|
|
|
|
|
backup to a network drive