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

为了能快速了解并处理您的问题，请提供以下基础信息：

面板、插件版本：7.9.0

系统版本：Windows  Server 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: [WinError 2] 系统找不到指定的文件。: 'D:/backup/database/Db_yake_ndp_picture_20230725_135834.bak'

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

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

sqlserver 2012