NetApp Community Update
This site will enter Read Only mode on July 23 as we prepare to move to a new platform.
You will still be able to view content, but posting and replying will be temporarily disabled.
To learn more, please review the information in this blog post.

Data Protection

SQL command ALTER DATABASE update manager__Clone SET AUTO_SHRINK OFF failed

HendersonD
3,070 Views

I am getting this error messge in my SQL Server event viewer:

SQL command ALTER DATABASE update manager__Clone SET AUTO_SHRINK OFF failed with error code 0x8004009c.

I am running Snapmanager for SQL 5.1, Snapdrive 6.3P1, and VSC 2.0.1. My SQL databases and logs are stored in VMDKs under NFS

Any idea what causes this and how to fix it?

1 REPLY 1

qzhang
3,070 Views

To workaround this issue, add a registry REG_DWORD value named "NotOffAutoshrink" under HKEY_LOCAL_MACHINE\SOFTWARE\Network Appliance\SnapManager for SQL Server\Server

Set the value to 1.

Thanks,

-Qing

Public