The process could not read file xxx due to OS error 53

简介: 在不同地域的两个SQL Server服务器上配置了复制(Replication)用于同步数据(生产环境配置有Replication,测试环境也配有Replication),两地通过专线连接起来,这些复制(Replication)已经稳定运行了一两年了, 但是前阵子,测试环境的SQL Se...

 

    在不同地域的两个SQL Server服务器上配置了复制(Replication)用于同步数据(生产环境配置有Replication,测试环境也配有Replication),两地通过专线连接起来,这些复制(Replication)已经稳定运行了一两年了, 但是前阵子,测试环境的SQL Server的Replication中突然遇到下面错误:

 

 

Error messages:

The process could not read file '\\xxx\xxx\xxx\xxx\xxx\xxx.pre' due to OS error 53. (Source: MSSQL_REPL, Error number: MSSQL_REPL20024)
Get help: http://help/MSSQL_REPL20024

 

image

 

 

分析研究了一下这个问题,当使用新的快照重新初始化订阅或配置一个新的发布时,都会遇到这个问题,原因在于指定的UNC 网络共享(例如 \\<computername>\snapshot)在订阅服务器无法访问,因为前阵子WannaCry病毒肆虐时,系统管理员禁用了在两地的专线上共享文件。所以导致了这个问题。这种情况,只能改用FTP Snapshot解决!

 

 

 

 

相关文章
成功解决OSError: Unable to open file (truncated file: eof = 8388608, sblock->base_addr = 0, stored_eof =
成功解决OSError: Unable to open file (truncated file: eof = 8388608, sblock->base_addr = 0, stored_eof =
成功解决OSError: Unable to open file (truncated file: eof = 8388608, sblock->base_addr = 0, stored_eof =
|
3月前
|
Linux Windows
fatal error C1083 无法打开包括文件 “sys/time.h” No such file or directory
fatal error C1083 无法打开包括文件 “sys/time.h” No such file or directory
130 0
autoreconf: failed to run autopoint: No such file or directory
autoreconf: failed to run autopoint: No such file or directory
134 0
|
机器学习/深度学习
成功解决NotFoundError (see above for traceback): Failed to create a directory: ; No such file or directo
成功解决NotFoundError (see above for traceback): Failed to create a directory: ; No such file or directo
|
Android开发
【错误记录】Android 文件查看错误 ( Error opening contents of device file ““: Cannot create directory )
【错误记录】Android 文件查看错误 ( Error opening contents of device file ““: Cannot create directory )
508 0
【错误记录】Android 文件查看错误 ( Error opening contents of device file ““: Cannot create directory )
|
SQL 监控
backup log is terminating abnormally because for write on file failed: 112(error not found)
昨天遇到一个案例,YourSQLDba做事务日志备份时失败,检查YourSQLDba输出的错误信息如下:   yMaint.backups backup log [gewem] to disk = 'M:\DB_BACKUP\LOG_BACKUP\xxxx_[2016-11-22_01h11m05_Tue]_logs.
1203 0