Unix Technical Forum

Error while archiving data in SQL Server 2000

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 ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 10:07 PM
=?Utf-8?B?a2ZyZXVkZW5yZWljaA==?=
 
Posts: n/a
Default Error while archiving data in SQL Server 2000

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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:13 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com