July 2, 2004 at 11:15 am
Ocassionally I have a database that Fails. There is no error in the Event Viewer in System Log at the time the job fails only at the Application Log which I screen captured below.
1.It takes 12 hours to run every night.
2.I have plenty of Disk space approx 340 GB.
3.I set the bak files to delete older than 2 days.
4.It's not running Transactional Logs.
5.The size of the databse is 96 Gigs
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer The following information is part of the event: 18210, BackupMedium::ReportIoError: write failure on backup device 'F:\sql\Data_Backups\Test\Test3_1_db_200407012025.BAK
Operating system error 2(The system cannot find the file specified.).
July 4, 2004 at 9:08 am
Are you backing up to tape or to a local drive? This is generally a hardware error, as I'm sure you've guessed. Have you done a read/write stress diagnostic on the drive/s? When you run this query, what do you get?
SELECT * FROM master..sysmessages WHERE error = 17055 ?
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
September 14, 2004 at 2:19 am
I am also getting the same error
'
The description for Event ID ( 17055 ) in Source ( MSSQLServer ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 18210, BackupMedium::ReportIoError: write failure on backup device 'E:\NAGAE'. Operating system error 2(The system cannot find the file specified.). '
Have you faced this problem before. any resolution??
Regards,
Rajkumar
October 27, 2004 at 3:54 am
Hi ... I get the same error
18210 :
BackupMedium::ReportIoError: write failure on backup device 'E:\SQLBackups\dbsFrng2\dbsFrng2_db_200410271022.BAK'. Operating system error 2(The system cannot find the file specified.).
Upon running the following query?
SELECT * FROM master..sysmessages WHERE error = 17055 ?
Results are as follows-
error severity dlevel description msglangid
----------- -------- ------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------
17055 16 128 %1 :%n%2 1033
(1 row(s) affected)
Please advise..
Thanks.
Kishor Shah
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply