在网络上备份！ [英] Backup on network!
问题描述
hello group，
a前几天我使用了以下备份声明和everthing
工作正常：
sp_addumpdevice' 'disk''，''pipedump''，''\\192.xxx \L \ data \ test.bak''
备份数据库测试到pipedump
同样的声明今天不起作用!!!!!
这是什么原因？
请不要告诉我检查网络路径是否存在！我已经检查了路径和权限。
一切都还可以！
提前谢谢
Debian
***通过Developersdex发送 http://www.developersdex.com ***
hello group,
a few days ago i used the following backup statement and everthing
worked fine:
sp_addumpdevice ''disk'',''pipedump'',''\\192.x.x.x\L\Data\test.bak''
Backup database Test to pipedump
The same statement is not working today!!!!!
What''s the reason?
Please dont tell me that check if the network path exists or not! I''ve
checked the path and permissions. Everything is ok!
Thanks in advance
Debian
*** Sent via Developersdex http://www.developersdex.com ***
推荐答案
您收到的错误消息是什么？这有助于缩小这个问题。
只是对它进行疯狂的猜测，但是你并没有放弃这个设备
今天再尝试添加它。
Stu
What''s the error message you are receiving? That would help narrow down
the problem a bit.
Just taking a wild-ass guess at it, though, you didn''t drop the device
before attempting to add it again today.
Stu
debian mojo （de*********@yahoo.com）写道：
debian mojo (de*********@yahoo.com) writes:
几天前我使用了以下备份声明并且翻了工作
工作正常：
sp_addumpdevice''disk''，''pipedump''，''\\192.xxx \L\Data\test.bak''
备份数据库测试到pipedump
同样的声明今天不起作用!!!!!
是什么原因？
a few days ago i used the following backup statement and everthing
worked fine:
sp_addumpdevice ''disk'',''pipedump'',''\\192.x.x.x\L\Data\test.bak''
Backup database Test to pipedump
The same statement is not working today!!!!!
What''s the reason?
我认为你是在错误的新闻组。如果你正在进行测验，
rec.games.trivia或rec.puzzles是我推荐的团体。
我的意思是，如果你真的寻求帮助，你会发布
错误信息，不是吗？如果你没有告诉我们什么是错的话怎么能告诉你
的原因是什么错误？
-
Erland Sommarskog，SQL Server MVP， es****@sommarskog.se
SQL Server SP3联机丛书
http://www.microsoft.com/sql/techinf...2000/books.asp
I think you are in the wrong newsgroup. If you are into making quizzes,
rec.games.trivia or rec.puzzles are the groups I would recommend.
I mean, if you were really asking for help, you would have posted the
error message, wouldn''t you? How could anyone be able tell you the
reason something is wrong, if you don''t tell us what is wrong?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
这是错误信息！
-------------------------- -----------------------------
服务器：消息3201，级别16，状态1，行1
无法打开备份设备''pipedump''。设备错误或设备脱机。
有关详细信息，请参阅SQL Server错误日志。
服务器：消息3013，级别16，状态1，行1
BACKUP DATABASE正在异常终止。
------------------------------- -------------------------
现在？
***通过开发人员发送的指南 http://www.developersdex.com ***
This is the error message!
-------------------------------------------------------
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ''pipedump''. Device error or device off-line.
See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
--------------------------------------------------------
Now?
*** Sent via Developersdex http://www.developersdex.com ***
这篇关于在网络上备份！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
