跳转到主内容

NetApp_Insight_2020.png 

SCSQL —由于访问权限不足错误、数据库无法进行备份

Views:
3
Visibility:
Public
Votes:
0
Category:
not set
Specialty:
not set
Last Updated:

适用于

适用于 SQL 的 SnapCenter 插件( SCSQL )

问题

  • SCSQL 数据库资源不可用于备份,并显示消息 " 不可用于备份。数据库不在 NetApp 存储上、自动关闭已启用或处于“可选择”字段中的恢复模式。“可选”字段中列出的任何可能原因都不有效(即数据库位于 NetApp 存储上、未启用自动关闭且处于联机状态)。
  • 在 SnapCenter 中为 SQL Server 主机枚举包含数据库文件的磁盘、而在该实例中作为帐户运行的 SnapCenter 在 SQL Server 中具有“ sysadmin ”权限。
  • 检索 SMSQL 日志中的数据库属性时( SQL Server 上的默认路径: C:\Program Files\NetApp \SnapCenter\SnapCenter Plug-in for Microsoft SQL Server\log\ ), SQL 资源的发现作业显示可能的权限错误:  

2020-05-12T15:03:36.4034711-04:00 DEBUG SmSql_1102 PID=[9568] TID=[4] Fetching Database [WideWorldImporters] properties...
2020-05-12T15:03:36.4194821-04:00 DEBUG SmSql_1102 PID=[9568] TID=[4] FillAGDetails
2020-05-12T15:03:36.4354940-04:00 DEBUG SmSql_1102 PID=[9568] TID=[4] Database Type: User
2020-05-12T15:03:36.4505045-04:00 DEBUG SmSql_1102 PID=[9568] TID=[4] Getting File groups
2020-05-12T15:03:36.4705188-04:00 DEBUG SmSql_1102 PID=[9568] TID=[4] Getting Log Files
2020-05-12T15:03:36.4935355-04:00 ERROR SmSql_1102 PID=[9568] TID=[4] Property Size is not available for Database '[USER_DB]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. 
2020-05-12T15:03:36.5095466-04:00 ERROR SmSql_1102 PID=[9568] TID=[4] Failed to get the details of database WideWorldImporters
2020-05-12T15:03:36.5245575-04:00 ERROR SmSql_1102 PID=[9568] TID=[4] ErrorCode (-1), ErrorMessage (Property Size is not available for Database '[WideWorldImporters]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. )

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support

 

 

  • 这篇文章对您有帮助吗?