Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 2007-04-27 : 11:29:57
|
| Hello,Yestarday night we had a log backup failure at 3.00 AM on a sql server 2000. After that the hourly log backup's went on smoothly.When I checked the sql server logs , it showed me the error:Backup Disk File:Create Media:Backup Device 'D:\mssql\backup\vmware\vmware_log' failed Operating system error=32 ( The process cannot access the file because it is being used by another process)I tried to google it , but could not get a good answer.Can anybody help me out what the error means. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-27 : 12:52:07
|
| Do you run file backup on the server? Most likely locked by file backup process. |
 |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-04-27 : 12:59:34
|
| Yes , I take the backup on the server. what does file backup lock mean. I will try to search in the mean timeThanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-27 : 13:07:37
|
| When backup program backups a file, it'll put lock on the file to prevent other processes to access the file. |
|
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-04-27 : 13:14:07
|
| Thanks for the explination. |
|
|
|
|
|
|
Log Backup Failed