James

Age: 35

Sysadmin (Windows, Linux) and DBA (SQL Server, MySQL).

17h
awarded Commentator
17h
accepted How can I verify whether a Windows cluster has previously been successfully validated?
17h
comment How can I verify whether a Windows cluster has previously been successfully validated?
Marking as accepted answer since it seems unlikely there is any persisted property that tracks whether previous validation succeeded.
17h
comment How can I verify whether a Windows cluster has previously been successfully validated?
OK, fair point that mentioning the directory where the reports exist could be useful information. That said, the question is clearly about programmatic checking and the content you pasted from Technet is obviously about clicking in the GUI. We'll probably end up parsing the report for keywords like 'failure', since there doesn't seem to be another option. When I looked into this several years ago, the SQL installer appeared to function the same way, checking the directory for the existence of a report and (apparently) failing if no such report existed.
19h
comment How can I verify whether a Windows cluster has previously been successfully validated?
The question is about programmatically checking, although parsing the report is one option. Unfortunately this answer only provides information anyone who knew enough to ask the question would already know.
23h
asked How can I verify whether a Windows cluster has previously been successfully validated?
Jul
17
revised Security implications of restoring a backup from an unknown source?
added 26 characters in body
Jul
17
answered Security implications of restoring a backup from an unknown source?
Jul
8
comment Is it possible to have the transaction log file write to a disk on a remote machine?
I don't think this addresses the actual question. The OP appears to be asking about hosting the transaction log on a remote server, over a CIFS share or some other means.
Jul
4
comment Not all members in a Windows group have permissions
Was DMN\Group a security group or a distribution group?
Jul
2
awarded Curious
Jun
23
comment ibdata1 corrupted, recover from ib_logfile?
Or hire Percona to do the work for you. (I'm assuming there's no backup to restore from.)
Jun
3
revised How to troubleshoot "client driver has sent multiple requests while the session is in single-user mode"
deleted 25 characters in body
Jun
3
comment How to troubleshoot "client driver has sent multiple requests while the session is in single-user mode"
@stacylaray Thanks. Any insight into why the problem would keep occurring with async=true enabled?
Jun
3
awarded Yearling
Jun
3
awarded Yearling
May
30
awarded Supporter
May
29
revised How to troubleshoot "client driver has sent multiple requests while the session is in single-user mode"
added 3 characters in body
May
29
comment How to troubleshoot "client driver has sent multiple requests while the session is in single-user mode"
Yes, I think Ladislav's answer to that question highlights why the dev probably can't disable MARS easily. The app is probably coded to execute multiple queries on the same connection in parallel, and disabling MARS in the connection string may just make the error happen more often unless the dev rewrites the app. The only answer may be 'debug your app, or rewrite it and turn MARS off.'
May
29
comment How to troubleshoot "client driver has sent multiple requests while the session is in single-user mode"
Yes, I may just suggest they test turning off MARS. I don't know why they are using it and doubt the developer does either as this is a spaghetti code legacy app handed down through many generations of developers. That said, I'm not sure if that will stop this error or make it occur incessantly.
1 2 3 4 5