March 13, 2011 at 6:33 am
Hi,
our one of the light speed job got failed due to below error.
please assistance on this what i have to do to troubleshoot
this issue.
Msg 50032, Sev 16, State 1: The process cannot access the file because it is being used by another process. LiteSpeed for SQL Server could not open the backup file: (J:\LS_Backup\edms_reports.bak). The previous system message is the reason for the failure. [SQLSTATE 42000]
March 13, 2011 at 7:08 am
Msg 50032, Sev 16, State 1: The process cannot access the file because it is being used by another process. LiteSpeed for SQL Server could not open the backup file: (J:\LS_Backup\edms_reports.bak). The previous system message is the reason for the failure. [SQLSTATE 42000]
I am not using LightSpeed. From the error message, looks like you are trying to either append the backup into an existing back file or overwrite the existing file; however the file has already been opened by someone else so LiteSpeed could not write to it. You may confirm if this is the case via attempt to rename the edms_reports.bak to something else. Hope this helps.
March 13, 2011 at 11:32 am
The message is pretty clear. Something is holding a lock on that file.
I used to get that at my old job when the process that copied our backups off to tape was running during a log backup.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 13, 2011 at 7:44 pm
Try using 'Process Explorer' or 'Handle' from Sysinternals to determine which app is using the file.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
March 14, 2011 at 7:24 am
I'm using LiteSpeed and have seen this before. In our case, it was simple because another backup job was running at the same time. Someone else created the same job twice.
Also, check to see that you are on at least version 6.X of LiteSpeed.
Thanks,
Rudy
Rudy
March 14, 2011 at 7:38 am
narasimhareddy.dba (3/13/2011)
Hi,our one of the light speed job got failed due to below error.
please assistance on this what i have to do to troubleshoot
this issue.
Msg 50032, Sev 16, State 1: The process cannot access the file because it is being used by another process. LiteSpeed for SQL Server could not open the backup file: (J:\LS_Backup\edms_reports.bak). The previous system message is the reason for the failure. [SQLSTATE 42000]
Are you still facing this error ?
M&M
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply