Could not open error log

Question

Could not open error log

timster

Ten Centuries

Points: 1033
More actions
August 22, 2010 at 1:08 am

#157160

Hey Guys
i am at loss, im getting the following error message on one of our SQL Servers sitting on a clustered SQL environment, this error has only started popping up over the last 5 hours but logs the error every couple of seconds in the event log,
initerrlog: Could not open error log file 'T:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
Operating system error = 21(error not found).
any ideas? as to how to resovle it?
Nothing has changed server like i said only started these error 5 6 hours ago

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ray Mond SSCertifiable Points: 7159 More actions · Answer 1

As per this page, error code 21 = 'The device is not ready.'. Can the node running the SQL Server instance access the T:\ path?

SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.

timster Ten Centuries Points: 1033 More actions · Answer 2

Hey Ray

thanks for the reply mate 🙂

Yes its the strangest thing im on the active node now and i can access the path perfectly ive checked permissions ect no luck?

SQL itself is writtening to the error log if i check through management studio

Thanks in advance

Ray Mond SSCertifiable Points: 7159 More actions · Answer 3

If the SQL Server instance is already writing to the error log successfully, but still raises that error in the event log, it's mighty strange. Sorry, I'm out of ideas.

SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 4

twebster-856509 (8/22/2010)
Hey Guys
i am at loss, im getting the following error message on one of our SQL Servers sitting on a clustered SQL environment, this error has only started popping up over the last 5 hours but logs the error every couple of seconds in the event log,
initerrlog: Could not open error log file 'T:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
Operating system error = 21(error not found).
any ideas? as to how to resovle it?
Nothing has changed server like i said only started these error 5 6 hours ago

Seems something is wrong with the errorlog.

Try cycling the error log:

EXEC sp_cycle_errorlog ;

GO

HTH,

Cheers !

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

Adiga One Orange Chip Points: 27284 More actions · Answer 5

Agree with Ray. The device was not ready when you received this message. Try running xp_cmdshell 'dir T:\' when you receive this error message. This will confirm if SQL Server is able to access this drive or not. If it is able to access this file, check if the ERRORLOG file is in use by some other application like Anti virus, Tape backup etc.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Rick.Cornell.SME SSCrazy Eights Points: 8597 More actions · Answer 6

Only thing you forgot is to make sure xp_cmdshell is enabled?

Simon Facer SSCertifiable Points: 5427 More actions · Answer 7

Is the T: Drive set as a dependency of SQL Server in the Cluster Group?