sql server clustering: Hello,

I have sql 2K on cluster Windows 3K but when i do a backup report this message on eventlo

Event Type: Erro
Event Source: MSSQLSERVE
Event Category: (2
Event ID: 1705
Date: 1/26/200
Time: 9:21:33 A
User: N/
Computer: JUPITE
Description
18204
BackupDiskFile::OpenMedia: Backup device 'F:\BD Migracion\stone_20040126' failed to open. Operating system error = 32(The process cannot access the file because it is being used by another process.)
an
Event Type: Erro
Event Source: MSSQLSERVE
Event Category: (6
Event ID: 1705
Date: 1/26/200
Time: 9:21:33 A
User: N/
Computer: JUPITE
Description
3041
BACKUP failed to complete the command BACKUP DATABASE [Stone] TO DISK = N'F:\BD Migracion\stone_20040126' WITH NOINIT , NOUNLOAD , NAME = N'Stone backup', NOSKIP , STATS = 10, NOFORMAT

thanks for help m

HM

Well just as the error message says, the backup file was
in use by another process. You should find out what this
other process was so that you can prevent it from locking
your backup file and causing the backup to fail.

The simplest way to find out what process may be holding
your backup file open -- when the backup job starts -- is
to use the command line utility nthandle.exe from
www.sysinternals.com. Add a step before the backup step in
the same job to run

cmd>nthandle.exe <yourBackupFileName>,

and make sure that the output report is specified for the
step so that you can review it to see what process is
putting a handle on the file, if the backup step fails
again.

With nthandle.exe, you don't need to specific the whole
backup file name. The some leading portion of it would
suffice.

Linchi

[quoted text, click to view]
Migracion\stone_20040126' failed to open. Operating system
error = 32(The process cannot access the file because it
is being used by another process.).
[quoted text, click to view]
[Stone] TO DISK = N'F:\BD Migracion\stone_20040126' WITH
NOINIT , NOUNLOAD , NAME = N'Stone backup', NOSKIP ,
STATS = 10, NOFORMAT
[quoted text, click to view]