September 15, 2015 at 7:58 am
I Cannot load sql server logs.
I cannot even make an odbc connection to the box.
From what I learn so far, the server is corrupted but functioning for the oltp.
Has anybody run a "repair" utility without heartburns?
yep, it is a clustered install.
Any input is welcome
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA
September 15, 2015 at 8:41 am
Paresh Motiwala (9/15/2015)
I Cannot load sql server logs.
SQL Server logs are simple text files. By default, you will find them in the data root, under the Log folder. File names are ERRORLOG, ERRORLOG.1, ERRORLOG.2, .... ERRORLOG.N with N = 6 by default.
ERRORLOG is the current log, ERRORLOG.1 is the previous one and so on.
I strongly suggest that you don't try to fix a clustered instance without knowing what's wrong first. Post any relevant ERRORLOG section first.
BTW, what does Cluster Administrator say about the instance? Is it online, offline, error state?
-- Gianluca Sartori
September 15, 2015 at 8:57 am
Agree with Gianluca.
Copy the error logs to another machine and open them with a text editor.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply