Yakesoft 发表于 2023-7-25 14:30:12

【待反馈】备份数据库报错

为了能快速了解并处理您的问题,请提供以下基础信息:面板、插件版本:7.9.0
系统版本:WindowsServer 2012R2

问题描述:备份数据库报错
相关截图(日志、错误):0 127.0.0.1 1433 sa None
Traceback (most recent call last):
File "pymssql.pyx", line 448, in pymssql.Cursor.execute
File "_mssql.pyx", line 1064, in _mssql.MSSQLConnection.execute_query
File "_mssql.pyx", line 1095, in _mssql.MSSQLConnection.execute_query
File "_mssql.pyx", line 1228, in _mssql.MSSQLConnection.format_and_run_query
File "_mssql.pyx", line 1639, in _mssql.check_cancel_and_raise
File "_mssql.pyx", line 1683, in _mssql.maybe_raise_MSSQLDatabaseException
_mssql.MSSQLDatabaseException: (3013, b'BACKUP DATABASE is terminating abnormally.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "D:\BtSoft\panel/class\panelMssql.py", line 164, in execute
    result = self.__DB_CUR.execute(sql)
File "pymssql.pyx", line 468, in pymssql.Cursor.execute
pymssql.OperationalError: (3013, b'BACKUP DATABASE is terminating abnormally.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n')

|---过滤目录
|---过滤异常 D:/backup/database/Db_yake_ndp_picture_20230725_135834.bak Traceback (most recent call last):
File "D:\BtSoft\panel\script\backup.py", line 312, in Zip
    f.write(item,item.replace(path,''))
File "C:\Program Files\python\lib\zipfile.py", line 1741, in write
    zinfo = ZipInfo.from_file(filename, arcname,
File "C:\Program Files\python\lib\zipfile.py", line 523, in from_file
    st = os.stat(filename)
FileNotFoundError: 系统找不到指定的文件。: 'D:/backup/database/Db_yake_ndp_picture_20230725_135834.bak'

谢花郎 发表于 2023-7-25 16:19:08

您好,您那边使用的Sql Server服务版本是2005吗?看了下Sql Server官方那边的3013错误代码,您具体看下官方文档处理,如要处理请备份好所有数据或者做个服务器快照再去操作
https://learn.microsoft.com/zh-cn/troubleshoot/windows-server/backup-and-storage/database-backup-error-3266-3013

Yakesoft 发表于 2023-7-31 17:19:09

谢花郎 发表于 2023-7-25 16:19
您好,您那边使用的Sql Server服务版本是2005吗?看了下Sql Server官方那边的3013错误代码,您具体看下官方 ...

sqlserver 2012
页: [1]
查看完整版本: 【待反馈】备份数据库报错