Backup job created using SQL Server Maintanence plan fail with the below error intermittently
"Executes as user: Domain\sqladmin sqlmaint.exe failed. [SQLSTATE 42000] [Error 22029]. The step failed"
Below are the error message found on SQL server Errror log.
BACKUP failed to complete the command BACKUP DATABASE [USER_DB_01] TO DISK = N'E:\MSSQL\BACKUP\USER_DB_01\USER_DB_01_db_200507092100.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
BackupMedium::ReportIoError: write failure on backup device 'E:\MSSQL\BACKUP\USER_DB_01\USER_DB_01_db_200507092100.BAK'. Operating system error 112(error not found).
Internal I/O request 0x53A97468: Op: Write, pBuffer: 0x154A0000, Size: 983040, Position: 3927840256, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0xEA1E1600, OffsetHigh: 0x0, m_buf: 0x154A0000, m_len: 983040, m_actualBytes: 0, m_errcode: 112, BackupFile: E:\MSSQL\BACKUP\USER_DB_01\USER_DB_01_db_200507092100.BAK
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment