跳转到主内容

NetApp wins prestigious Coveo Relevance Pinnacle Award. Learn more!

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

适用场景

  • SnapCenter 服务器
  • 适用于 SQL 的 SnapCenter 插件( SCSQL )

问题描述

SCSQL数据库资源不可用于备份、并显示消息

Not available for backup. DB is not on NetApp Storage, auto-close is enabled or in recovery mode

可选 字段中、而以下项保持true。

  • 可选 字段中列出的所有可能原因均无效(即数据库位于 NetApp 存储上,未启用自动关闭且处于联机状态)。
  • 正在 SCSQL 主机中枚举用于存放数据库文件的磁盘,此实例的 SC Run as 帐户在 SQL Server 中具有 "sysadmin" 权限。

在中、上述日志可能会显示以下消息

  • SmSql_<JOB>.log (SQL Server上的默认路径: <installation_path>\NetApp\SnapCenter\SnapCenter Plug-in for Microsoft SQL Server\log\)中检索作业ID <job>的数据库属性时、SQL资源的发现作业可能会显示权限错误:

DEBUG SmSql_1102 PID=[9568] TID=[4] Fetching Database [<DATABASE_NAME>] properties...
DEBUG SmSql_1102 PID=[9568] TID=[4] FillAGDetails
DEBUG SmSql_1102 PID=[9568] TID=[4] Database Type: User
DEBUG SmSql_1102 PID=[9568] TID=[4] Getting File groups
DEBUG SmSql_1102 PID=[9568] TID=[4] Getting Log Files
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. 
ERROR SmSql_1102 PID=[9568] TID=[4] Failed to get the details of database <DATABASE_NAME>
ERROR SmSql_1102 PID=[9568] TID=[4] ErrorCode (-1), ErrorMessage (Property Size is not available for Database '[<DATABASE_NAME>]'.
This property may not exist for this object, or may not be retrievable due to insufficient access rights. )

  • 或者、连接错误也可能会显示类似的消息:

ErrorCode (10010), ErrorMessage (The SQL instance '<HOSTNAME>\<INSTANCE_NAME>' is either stopped or
the user '<DOMAIN>\<ACCOUNT>' does not have required permission to connect.

Error: Failed to connect to server <HOSTNAME>\<INSTANCE_NAME>.)

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device