Backup Problem

Hello Everyone,
We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
Windows 2003 Ent) from one subnet to another. Everything went well
(apparently) until we realized that our backups are failing (both the
existing jobs and manual backups) after the change in ip/subnet was
done. All backup attempts return with errrors similar to these:
===
18204 :
BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
failed to open. Operating system error = 32(The process cannot access
the file because it is being used by another process.).
===
3041 :
BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
===
When the manual backup is initiated without Verification, no (popup)
error is generated (but the error above is still logged on the event
log) and the backup says it ran successfully. When the backup file is
checked, the size is Zero (0) kb.
There is no apparent problem in connecting to both the two instances
of the server and applications are working okay, it's just the backup
problem that is bugging us.
drive Q = quorum
drive F = one of the shared drives with 20Gb+ remaining
The database that we are attempting to backup is just about 11Gb in
size.
Any help is appreciated.
Thanks.
Aramid
Just a quick question - were you backing up to a shared network drive
previously? What if you try backing up to the fully qualified UNC Path
instead?
"aramid" <aramid@.hotmail.com> wrote in message
news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===
> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===
>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>
|||Thanks for your reply, Michael.
We are not backing up to any shared network drive, just to this drive,
which is one of the logical drives on an external disk array attached
to the cluster.
Aramid
On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
wrote:

>Just a quick question - were you backing up to a shared network drive
>previously? What if you try backing up to the fully qualified UNC Path
>instead?
>"aramid" <aramid@.hotmail.com> wrote in message
>news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com.. .
>
|||aramid
It seems that is permission or OS issue . We have recently moved to the
cluster and what i did in the backup script only changed the D:\ Driver
path to N:\ driver path. Run SQL Server Profile to see what is going on.
Have you searched on internet for those errors?
"aramid" <aramid@.hotmail.com> wrote in message
news:0ouj51dm2esqntk6pegt6f37m36f4g8brj@.4ax.com...
> Thanks for your reply, Michael.
> We are not backing up to any shared network drive, just to this drive,
> which is one of the logical drives on an external disk array attached
> to the cluster.
> Aramid
> On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
> wrote:
>
|||SQL Server say that the backup file is used by some other process. I'd get a tool with which I can
check who is using the file...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===
> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===
>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>