backup failed os error=32

• OakDBA

  Say Hey Kid

  Points: 673

  More actions

  October 29, 2002 at 9:53 am

  #105398

  I'm having problems backing up a particular db (SQL Server 7). I am seeing the following message in the SQL Server Log: "18204 :

  BackupDiskFile::CreateMedia: Backup device 'E:\BACKUP\DB_FULLBackup' failed to create. Operating system error = 32(The process cannot access the file because it is being used by another process.).

  Any idea how to figure out what the offending process is?

  TIA

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  October 29, 2002 at 10:16 am

  #439714

  You have an OS link. Go into Control Panel|Server or My Computers|Manage, depending on OS and look for open files. This should give you the login.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones