在数据库备份中有问题 [英] having issue in database backup

问题描述

我想在网络上进行数据库备份。有许多终端，如pc01，pc02，pc10，& pc51。我从pc 01上的pc 51获取备份。错误即将来临。同时从PC机上安装PC 51&另外，它正在成功发生。



错误是

 < span class =code-leadattribute> DatabaseName   backup   failed ，错误： [Microsoft] [ODBC  SQL  服务器驱动程序] [SQL服务器]写 '\\PC01 \ c：\ appeback \ PC51.dat'失败， status   =   64 。 参见    SQL  服务器 错误  log   for   more   details 。 
 [Microsoft] [ODBC  SQL  服务器驱动程序] [SQL Server] BACKUP  DATABASE    终止 异常。

请说明原因是什么以及如何纠正。

解决方案

我们不能 - 这是一个通用的错误信息。

看看它：它告诉你该怎么做： 有关详细信息，请参阅SQL Server错误日志。



希望有足够的信息可以让您知道问题所在，如果不能直接解决！

\\PC01\c：\\\
exback \ PC51.dat



尝试更换它



\\PC01\c




\\ appeback \ PC51.dat



您无法像在本地计算机上那样访问远程计算机上的硬盘。

必须在远程计算机上激活管理共享（尝试访问它们的用户必须是远程计算机上本地管理员组的成员）。

I want to take database backup on network. There are number of terminals like pc01, pc02 , pc10, & pc51. I taking backup from pc 51 on pc 01. Error is coming. whilst taking from pc 51 on pc 02 & other, it is happening sucessfully.

Error is

DatabaseName backup failed, Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on '\\PC01\c:\nexback\PC51.dat' failed, status = 64. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.

Please tell what is the reason and how to rectify.

解决方案

We can't - it's a generic error message.
Look at it though: it tells you what to do: "See the SQL Server error log for more details."

Hopefully, there will be sufficient information there to let you know what the problem is, if not solve it directly!

\\PC01\c:\nexback\PC51.dat

Try to replace it with

\\PC01\c




\nexback\PC51.dat

You cannot access a hard drive on a distant computer the same way as you do on a local one.
Administrative shares have to be activated on the distant computer (and the user who tries to access them has to be a member of the local administrators group on the distant computer).

这篇关于在数据库备份中有问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！