Home Forums Article Discussions Article Discussions by Author Discuss content posted by Eirikur Eiriksson Bringing them back from the dead RE: Bringing them back from the dead
September 11, 2018 at 7:37 am
Sal Young - Tuesday, September 11, 2018 6:53 AMThis is a promising script but I'm having some issues.
- If there are other file(s) or folder(s) in the drive that match the pattern "ERRORLOG" it may go to that folder instead of the location to the SQL error log files
- After renaming the other ERRORLOG folder, i still got the following message which I'm not sure if the script is working as expected
The current system date and time:
Tue 09/11/2018- 7:39:57.12
-------------------------------------------------------------------------
Operating system:
Microsoft Windows [Version 10.0.17134.228]
-------------------------------------------------------------------------
Testing Error Search: FINDSTR /I /R /G:"C:\TSES_V02\TEST_SEARCH.txt" "C:\Program*"
This should match once in every log file.
[Failed] Test string not found.
-------------------------------------------------------------------------
Severity Level 10 ( Memory )
No Severity Level 10 ( Memory ) errors found.
-------------------------------------------------------------------------
Severity Level 10 ( Disk )
No Severity Level 10 ( Disk ) errors found.
-------------------------------------------------------------------------
Severity Level 11
No Severity Level 11 errors found.
-------------------------------------------------------------------------
Severity Level 12
No Severity Level 12 errors found.
-------------------------------------------------------------------------
Severity Level 13
No Severity Level 13 errors found.
-------------------------------------------------------------------------
Severity Level 14
No Severity Level 14 errors found.
-------------------------------------------------------------------------
Severity Level 16 (Backup)
No Severity Level 16 (Backup) errors found.
-------------------------------------------------------------------------
Severity Level 16 (Restore)
No Severity Level 16 (Restore) errors found.
-------------------------------------------------------------------------
Severity Level 17
No Severity Level 17 errors found.
-------------------------------------------------------------------------
Severity Level 18
No Severity Level 18 errors found.
-------------------------------------------------------------------------
Severity Level 19
No Severity Level 19 errors found.
-------------------------------------------------------------------------
Severity Level 20
No Severity Level 20 errors found.
-------------------------------------------------------------------------
Severity Level 21
No Severity Level 21 errors found.
-------------------------------------------------------------------------
Severity Level 22
No Severity Level 22 errors found.
-------------------------------------------------------------------------
Severity Level 23
No Severity Level 23 errors found.
-------------------------------------------------------------------------
Severity Level 24
No Severity Level 24 errors found.
-------------------------------------------------------------------------
Haven't come across this situation, the assumption is that the patterns in the file C:\TSES_V02\TEST_SEARCH.txt will identify the error log files, neither the location of the files nor the file names.
😎
Can you run the script again in verbose mode and ping back the output?