RE: Backup Failed
From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 01/24/05
- Next message: Sue Hoegemeier: "Re: Who deleted my records?"
- Previous message: Keith Kratochvil: "Re: Backup Failed"
- In reply to: MS User: "Backup Failed"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 24 Jan 2005 08:11:05 -0800
Hi
Anti-Virus and Backup software can hold locks on a file. Check that AV
excludes the SQL files (.MDF, LDF, NDF and BAK)
Check if your backup software is still running it's backup (some badly
behaved backup agents don't release locks if the backup aborts).
Regards
Mike
"MS User" wrote:
> 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
>
>
>
- Next message: Sue Hoegemeier: "Re: Who deleted my records?"
- Previous message: Keith Kratochvil: "Re: Backup Failed"
- In reply to: MS User: "Backup Failed"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
