asked on
Db backup issues
Hi Experts, I am having backup issues with a user db for 3 days in a row now. The error I get from the sqlserver error log is the following (In this order):
BackupMedium::ReportIoErro
Internal I/O request 0x36685D18: Op: Write, pBuffer: 0x0D220000, Size: 983040, Position: 44046096896, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x415A1A00, OffsetHigh: 0xA, m_buf: 0x0D220000, m_len: 983040, m_actualBytes: 0, m_errcode: 33, BackupFile: D:\SqlServer_Backups\Palb_
BACKUP failed to complete the command BACKUP DATABASE [Palb] TO DISK = N'D:\SqlServer_Backups\Pal
BackupMedium::ReportIoErro
Internal I/O request 0x36685D18: Op: Write, pBuffer: 0x0D220000, Size: 983040, Position: 44046096896, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x415A1A00, OffsetHigh: 0xA, m_buf: 0x0D220000, m_len: 983040, m_actualBytes: 0, m_errcode: 33, BackupFile: D:\SqlServer_Backups\Palb_
BACKUP failed to complete the command BACKUP DATABASE [Palb] TO DISK = N'D:\SqlServer_Backups\Pal
Microsoft SQL Server
Last Comment
EugeneZ
I think I would restart sql server + sql agent complete once...
Run Sp_who2 in query analyzer or management studio if you using SQL 2005, check the results if there is a backup thread that might still be holding on to the backup file. if it is you can kill that process.
like angell lll says - restart - this could also terminate the process that is holding on to the file.
like angell lll says - restart - this could also terminate the process that is holding on to the file.
ASKER
That is the problem I can not see which process is holding it. I can not see a process that has to do with the backup. I did ask for a time before the next backup to restart the sqlserver to resolve the problem. Let me see if I get that time slot.....
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.