Hello - we are seeing an error on our SQL Server 2012 that is puzzling us. It's an Error 823 and its occurring every minute of the day, for as far back as the event log goes. the strange thing is ity does not seem to impact the DB itself - but its causing our Arcserve SQL backup job to fail when backing up ANY of the many DB's on the server. We called Arcserve, and they tell us "fix this SQL error, and the backup job should work". So we have tried restoring the DB from the last good backup, and also ran a DBCC checkDB on the DB in question, to no avail. Here is the error:
"The operating system returned error 64(The specified network name is no longer available.) to SQL Server during a read at offset 0x0000000016a000 in file '\\lacosql2\X\AX2012R3BaselineDEV10.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online."
We have also confirmed the UNC path to the DB file (on another server - "lacosql2") that the path works and is good. We also checked the free space on the drive, and there is 132GB free. Also checked and verified that the MDB file is actually there.
Out of ideas now..
Thanks for your help.