Backup Job Notification Error

I continue to receive a message alert that my backup job
failed for three of my servers every morning while in the
real sense the backups completed successfully. I did
reboot one of the servers but this did not reslove the
issue. Any help on this will be appreaciated please.
Are these databases in Simple recovery mode? If so, any
transaction log backup will fail, and a SQL Maintenance
Plan will show an overall failure to execute (although the
full backups will run).
Also, have you tried restoring one of the backups that
completed? Another thing to check is to make sure the job
doesn't have additional steps, or operator alerts, or any
of the optional settings on. If execution of any of the
other activities should occur, overall failure of the job
may be flagged.
Also, in the job history, what is the exact error you're
receiving -- that is, when the Show Details option is
checked?
>--Original Message--
>I continue to receive a message alert that my backup job
>failed for three of my servers every morning while in the
>real sense the backups completed successfully. I did
>reboot one of the servers but this did not reslove the
>issue. Any help on this will be appreaciated please.
>.
>
|||here is the error message. any new lead.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.

>--Original Message--
>Are these databases in Simple recovery mode? If so, any
>transaction log backup will fail, and a SQL Maintenance
>Plan will show an overall failure to execute (although
the
>full backups will run).
>Also, have you tried restoring one of the backups that
>completed? Another thing to check is to make sure the
job[vbcol=seagreen]
>doesn't have additional steps, or operator alerts, or any
>of the optional settings on. If execution of any of the
>other activities should occur, overall failure of the job
>may be flagged.
>Also, in the job history, what is the exact error you're
>receiving -- that is, when the Show Details option is
>checked?
the
>.
>
|||Here are the details when show step details is selected.
Executed as user: BHCS\sqlsrv. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.
[vbcol=seagreen]
>--Original Message--
>here is the error message. any new lead.
>The job failed. The Job was invoked by Schedule 7
>(Schedule 1). The last step to run was step 1 (Step 1).
>
>Thanks,
>Aboki.
>
>the
>job
any[vbcol=seagreen]
job[vbcol=seagreen]
job
>the
>.
>
|||Check to ensure it is the backup step which is failing... Often the step
PRIOR to backup fails... That would be doing the DBCC and having selected
"Repair" option.. This option requires the db to be in single-user mode. If
users are in the db, this step fails...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Aboki" <hcokoli@.yahoo.com> wrote in message
news:426301c4731f$6ac87900$a401280a@.phx.gbl...
> I continue to receive a message alert that my backup job
> failed for three of my servers every morning while in the
> real sense the backups completed successfully. I did
> reboot one of the servers but this did not reslove the
> issue. Any help on this will be appreaciated please.

Backup Job Notification Error

I continue to receive a message alert that my backup job
failed for three of my servers every morning while in the
real sense the backups completed successfully. I did
reboot one of the servers but this did not reslove the
issue. Any help on this will be appreaciated please.Are these databases in Simple recovery mode? If so, any
transaction log backup will fail, and a SQL Maintenance
Plan will show an overall failure to execute (although the
full backups will run).
Also, have you tried restoring one of the backups that
completed? Another thing to check is to make sure the job
doesn't have additional steps, or operator alerts, or any
of the optional settings on. If execution of any of the
other activities should occur, overall failure of the job
may be flagged.
Also, in the job history, what is the exact error you're
receiving -- that is, when the Show Details option is
checked?
>--Original Message--
>I continue to receive a message alert that my backup job
>failed for three of my servers every morning while in the
>real sense the backups completed successfully. I did
>reboot one of the servers but this did not reslove the
>issue. Any help on this will be appreaciated please.
>.
>|||here is the error message. any new lead.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.
>--Original Message--
>Are these databases in Simple recovery mode? If so, any
>transaction log backup will fail, and a SQL Maintenance
>Plan will show an overall failure to execute (although
the
>full backups will run).
>Also, have you tried restoring one of the backups that
>completed? Another thing to check is to make sure the
job
>doesn't have additional steps, or operator alerts, or any
>of the optional settings on. If execution of any of the
>other activities should occur, overall failure of the job
>may be flagged.
>Also, in the job history, what is the exact error you're
>receiving -- that is, when the Show Details option is
>checked?
>>--Original Message--
>>I continue to receive a message alert that my backup job
>>failed for three of my servers every morning while in
the
>>real sense the backups completed successfully. I did
>>reboot one of the servers but this did not reslove the
>>issue. Any help on this will be appreaciated please.
>>.
>.
>|||Here are the details when show step details is selected.
Executed as user: BHCS\sqlsrv. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.
>--Original Message--
>here is the error message. any new lead.
>The job failed. The Job was invoked by Schedule 7
>(Schedule 1). The last step to run was step 1 (Step 1).
>
>Thanks,
>Aboki.
>
>>--Original Message--
>>Are these databases in Simple recovery mode? If so, any
>>transaction log backup will fail, and a SQL Maintenance
>>Plan will show an overall failure to execute (although
>the
>>full backups will run).
>>Also, have you tried restoring one of the backups that
>>completed? Another thing to check is to make sure the
>job
>>doesn't have additional steps, or operator alerts, or
any
>>of the optional settings on. If execution of any of the
>>other activities should occur, overall failure of the
job
>>may be flagged.
>>Also, in the job history, what is the exact error you're
>>receiving -- that is, when the Show Details option is
>>checked?
>>--Original Message--
>>I continue to receive a message alert that my backup
job
>>failed for three of my servers every morning while in
>the
>>real sense the backups completed successfully. I did
>>reboot one of the servers but this did not reslove the
>>issue. Any help on this will be appreaciated please.
>>.
>>.
>.
>|||Check to ensure it is the backup step which is failing... Often the step
PRIOR to backup fails... That would be doing the DBCC and having selected
"Repair" option.. This option requires the db to be in single-user mode. If
users are in the db, this step fails...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Aboki" <hcokoli@.yahoo.com> wrote in message
news:426301c4731f$6ac87900$a401280a@.phx.gbl...
> I continue to receive a message alert that my backup job
> failed for three of my servers every morning while in the
> real sense the backups completed successfully. I did
> reboot one of the servers but this did not reslove the
> issue. Any help on this will be appreaciated please.

Backup Job Notification Error

I continue to receive a message alert that my backup job
failed for three of my servers every morning while in the
real sense the backups completed successfully. I did
reboot one of the servers but this did not reslove the
issue. Any help on this will be appreaciated please.Are these databases in Simple recovery mode? If so, any
transaction log backup will fail, and a SQL Maintenance
Plan will show an overall failure to execute (although the
full backups will run).
Also, have you tried restoring one of the backups that
completed? Another thing to check is to make sure the job
doesn't have additional steps, or operator alerts, or any
of the optional settings on. If execution of any of the
other activities should occur, overall failure of the job
may be flagged.
Also, in the job history, what is the exact error you're
receiving -- that is, when the Show Details option is
checked?
>--Original Message--
>I continue to receive a message alert that my backup job
>failed for three of my servers every morning while in the
>real sense the backups completed successfully. I did
>reboot one of the servers but this did not reslove the
>issue. Any help on this will be appreaciated please.
>.
>|||here is the error message. any new lead.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.

>--Original Message--
>Are these databases in Simple recovery mode? If so, any
>transaction log backup will fail, and a SQL Maintenance
>Plan will show an overall failure to execute (although
the
>full backups will run).
>Also, have you tried restoring one of the backups that
>completed? Another thing to check is to make sure the
job
>doesn't have additional steps, or operator alerts, or any
>of the optional settings on. If execution of any of the
>other activities should occur, overall failure of the job
>may be flagged.
>Also, in the job history, what is the exact error you're
>receiving -- that is, when the Show Details option is
>checked?
the[vbcol=seagreen]
>.
>|||Here are the details when show step details is selected.
Executed as user: BHCS\sqlsrv. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.

>--Original Message--
>here is the error message. any new lead.
>The job failed. The Job was invoked by Schedule 7
>(Schedule 1). The last step to run was step 1 (Step 1).
>
>Thanks,
>Aboki.
>
>the
>job
any[vbcol=seagreen]
job[vbcol=seagreen]
job[vbcol=seagreen]
>the
>.
>|||Check to ensure it is the backup step which is failing... Often the step
PRIOR to backup fails... That would be doing the DBCC and having selected
"Repair" option.. This option requires the db to be in single-user mode. If
users are in the db, this step fails...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Aboki" <hcokoli@.yahoo.com> wrote in message
news:426301c4731f$6ac87900$a401280a@.phx.gbl...
> I continue to receive a message alert that my backup job
> failed for three of my servers every morning while in the
> real sense the backups completed successfully. I did
> reboot one of the servers but this did not reslove the
> issue. Any help on this will be appreaciated please.

backup hang

Hi All,
I have a problem with the backup hang. I make a backup
through EM, completed + verified as well. It doesn't
matter what location I choose. For this example, I used
the default backup SQL location on the same drive.
When I try to restore the backup, it starts, but the
dialogbox did not show progress and it stays there for
ever. In the errorlog I have the error:
udopen: Operating system error 32(The process cannot
access the file because it is being used by another
process.) during the creation/opening of physical device
D:\MRE-DEV-SQL_data\MSSQL\Data\ENT_DATA.mdf.
2003-10-09 15:09:30.67 spid58 FCB::Open failed: Could
not open device D:\MRE-DEV-
SQL_data\MSSQL\Data\ENT_DATA.mdf for virtual device number
(VDN) 0.
What I could look at?
Thanks a lot for the help.Seems like you try to restore to a new database name but you don't specify for that database to be
created to use new filename, meaning that SQL Server tries to use the file names that are already in
use by the old database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"MJ" <MJ@.mjsql.com> wrote in message news:06b601c38f4d$f73930c0$a001280a@.phx.gbl...
> Hi All,
> I have a problem with the backup hang. I make a backup
> through EM, completed + verified as well. It doesn't
> matter what location I choose. For this example, I used
> the default backup SQL location on the same drive.
> When I try to restore the backup, it starts, but the
> dialogbox did not show progress and it stays there for
> ever. In the errorlog I have the error:
> udopen: Operating system error 32(The process cannot
> access the file because it is being used by another
> process.) during the creation/opening of physical device
> D:\MRE-DEV-SQL_data\MSSQL\Data\ENT_DATA.mdf.
> 2003-10-09 15:09:30.67 spid58 FCB::Open failed: Could
> not open device D:\MRE-DEV-
> SQL_data\MSSQL\Data\ENT_DATA.mdf for virtual device number
> (VDN) 0.
> What I could look at?
> Thanks a lot for the help.