This is a discussion on Error while archiving data in SQL Server 2000 within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I support an application that uses SQL Server on the back end. The tables contain only conifguration and tracking ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I support an application that uses SQL Server on the back end. The tables contain only conifguration and tracking formation for files located on the HD. Our Archiving processes queries the database to find data tracking information that is old enough to be deleted. After building a file containing datagbase information and a copy of the data, (this includes files from mulitple directories being combined.) we then delete the rows from the database and remove the files from the HD. In this process we have a customer that is receiving the follow error after a few hours of database timeouts. The customer needs to adjust the processing so that the database timeouts do not occur as a resolution to the issue. But when this error occurs the Sytem Mutex is not release for the Archive process and all subsequent processes fail. The only resolution to the stuck mutex is to reboot the entire server. I'm looking for an answer to why we are getting the unknown error so that when a server is over taxed and timeing out we can back out the process gracefully. The error is "An unknown error occurred while accessing an unnamed file" What does this error mean and how can I troubleshoot to figure out what unnamed file is erroring? |