Unable to open or read TSX cache file - TSX Server

• ImYourDBA

  SSCertifiable

  Points: 5654

  More actions

  November 18, 2011 at 1:08 pm

  #390905

  I'm getting an error in the SQL Server Agent log when starting up the agent and haven't been able to find anything about it anywhere.

  Message

  [419] Unable to open or read TSX cache file 'F:\Data\MSSQL10_50.MSSQLSERVER\MSSQL\JOBS\TSXCACHE.BIN' (win32 error code: 2)

  Anyone have any ideas?

  Owner & Principal SQL Server Consultant
  Im Your DBA, Inc.
  https://www.imyourdba.com/

• okbangas

  SSChampion

  Points: 11773

  More actions

  November 18, 2011 at 4:32 pm

  #1410245

  Error code 2 means "File Not Found", and there is a myriad of reasons for files not existing where they should.

  Edit: By the way, when you looked for a solution, did you try SQLServerCentral

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]