This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Monitoring DB Free Space on a SMB Share

Question
0

Sign in to vote

Hi guys,

Customer does (unfortunately) have some DB Files on a SMB Share and we are constantly getting the error although the path definitely is accessible.... -- anyone any idea?

Event ID: 4211. Management Group: XYZ. Script: GetSQL2016DBFreeSpace.vbs. Version: 7.0.7.0 : The next errors occurred:
Database: abcDB Error: Cannot get FreeSpace of SMB shared '\\test01.test.corp\data' ('\\test01.test.corp\data\SQLSrv6\SQLTI40\testdb.mdf')

Error occurred during data file free space calculation for database 'abcDB'
Error Number: 76
Description: Path not found
Instance: SQLTI40

Thanks in advance,

Markus

Tuesday, November 26, 2019 8:43 AM

Answers

1

Sign in to vote
Hi,

There's a similar thread about this in the below link, you can refer to Guy_In_IT's last reply in the thread:

"They have recommended that if we give the Computer account of the database server read access this may resolve the issue."

Reference:
https://social.technet.microsoft.com/Forums/lync/en-US/a78ab316-4c89-4d71-a0d9-6cf0521992bc/mssql-2016-monitoring-warning?forum=operationsmanagermgmtpacks

Best regards,
Leon
Blog: https://thesystemcenterblog.com LinkedIn:
- Proposed as answer by AlexZhu_775Microsoft contingent staff Thursday, November 28, 2019 5:28 AM
- Marked as answer by Markus--2015 Monday, December 2, 2019 9:32 AM
Tuesday, November 26, 2019 9:00 AM

All replies

0

Sign in to vote

With what run as account is the MP running, and does that account have access to the share?

Tuesday, November 26, 2019 8:52 AM
1

Sign in to vote
Hi,

There's a similar thread about this in the below link, you can refer to Guy_In_IT's last reply in the thread:

"They have recommended that if we give the Computer account of the database server read access this may resolve the issue."

Reference:
https://social.technet.microsoft.com/Forums/lync/en-US/a78ab316-4c89-4d71-a0d9-6cf0521992bc/mssql-2016-monitoring-warning?forum=operationsmanagermgmtpacks

Best regards,
Leon
Blog: https://thesystemcenterblog.com LinkedIn:
- Proposed as answer by AlexZhu_775Microsoft contingent staff Thursday, November 28, 2019 5:28 AM
- Marked as answer by Markus--2015 Monday, December 2, 2019 9:32 AM
Tuesday, November 26, 2019 9:00 AM
1

Sign in to vote

And the post just above in that other thread explains the reason why. Just sayin' : ]

Tuesday, November 26, 2019 10:04 AM
0

Sign in to vote

Local System and it does not have access. But I doubt it will run with an AD RunAs Account!?

Monday, December 2, 2019 9:29 AM