Home > Archive > MS SQL Server ODBC > February 2006 > Error while archiving data in SQL Server 2000









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Error while archiving data in SQL Server 2000
kfreudenreich

2006-02-25, 9:29 am

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?
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com