Backup Failed

From: MS User (sqlman_at_sql.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 09:40:30 -0600

SQL 2K

We are having an issue with our data warehouse database failing on backup
with

2005-01-23 09:53:25.64 spid55 BackupMedium::ReportIoError: write failure
on backup device
'D:\SqlData\MSSQL$WAREHOUSE1\BACKUP\My_db_200501230900.BAK'. Operating
system error 33(The process cannot access the file because another process
has locked a portion of the file.).
2005-01-23 09:53:25.67 spid55 Internal I/O request 0x3D80DAE8: Op: Write,
pBuffer: 0x153C0000, Size: 983040, Position: 47255394816, UMS: Internal:
0x103, InternalHigh: 0x0, Offset: 0xA41A00, OffsetHigh: 0xB, m_buf:
0x153C0000, m_len: 983040, m_actualBytes: 0, m_errcode: 33, BackupFile:
D:\SqlData\MSSQL$WAREHOUSE1\BACKUP\My_db_200501230900.BAK
2005-01-23 09:53:25.69 backup BACKUP failed to complete the command
BACKUP DATABASE [INFO_PROD] TO DISK =
N'D:\SqlData\MSSQL$WAREHOUSE1\BACKUP\My_db_200501230900.BAK' WITH INIT ,
NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Last week we had the same issue and rebooting the server did helped.

Any thoughts on this lock on the backup file.

Thanks
Robert

Relevant Pages

  • Event ID: 17055 with MSSQL on Win 2003 SBS Prem.
    ... I/O error on backup or restore restart-checkpoint ... Operating ... system error 3(The system cannot find the path ...
    (microsoft.public.windows.server.sbs)
  • Backup Failed
    ... We are having an issue with our data warehouse database failing on backup ... Operating ... system error 33(The process cannot access the file because another process ...
    (microsoft.public.sqlserver.server)
  • Backup Failed
    ... We are having an issue with our data warehouse database failing on backup ... Operating ... system error 33(The process cannot access the file because another process ...
    (microsoft.public.sqlserver.programming)
  • Re: Customize MyDocuments
    ... Ken Blake - Microsoft MVP Windows: ... NEVER put my personal files on the same drive with the operating ... partitions facilitates that backup. ...
    (microsoft.public.windowsxp.customize)
  • RE: HUGE mistake, please help
    ... change first boot devise to cd and then boot from your ... to reinstalll the operating syatem. ... have your backup cd then have dell mail it to you. ... >if I ruined moms computer and she just got it 1 week ...
    (microsoft.public.windowsxp.general)