backup failed

Hi Jeff,
First check the job history information. Right-click your job, View History
and click the + sign to see the job steps.
Also, check the SQL Server error log for related error messages.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Jeff" wrote:

> hey
> Sql Server 2005
> I have Sql Server 2005 installed on a server. Each night the Sql Server
> Agent start a job. This job fails. I wonder what causing this job to fail.
> I've checked in Event viewer and it doesn't say more than "the job failed,
> the job was invoked by Schedule 2 (backup_db), the last step to run was 1
> (subplan)"
> Any ideas how to find what causing this? Could I manually start this Sql
> Server Agent job and then see what causing the job to failed?
> This job have been running for months, it's only during the last 3 days it
> started to fail
> Basically I want to fix this job so it get completed successfully, so I
> thought knowing what causing it to fail could help solving the problem...
> but the main thing is that I want the job to complete successfully
> any suggestions?
>
>
Hi Jeff
It looks like it is having problems sending the email notification. Try
changing the maintenance plan to remove these. There is probably a notify
operator task that needs to be re-configured. Also check that you can send
test emails for database mail and SQL Agent mail configuration (in the
properties)
John
"Jeff" wrote:

> In the the Log File Viewer, I select Maintenace Plan and there I see to rows
> marked with a green icon and a + sign to the left... I clicked on the + to
> reveal what's under the row.. then it revealed a row with an red stop icon
> to the left...
> On one of the rows with red stop icon, I read this error message:
> Could not generate mail report.An exception occurred while executing a
> Transact-SQL statement or batch.No global profile is configured. Specify a
> profile name in the @.profile_name parameter.
> any suggestions?
>
>
|||Hi Jeff
It may be that the account had been disabled but the mailbox remained until
more recently!!
At least everything works now!
John
"Jeff" wrote:

> I modifyed the Maintenance Plan -> selected the Maintenance plan I selected
> "Modify". then I opened the "Reporting and Logging" window and unchecked
> "Send report to an email recipient". Maybe the error was here... the agent
> operator set as recipient was an domain account which not exist anymore
> It's a long time since this domain account was removed - strange if caused
> problem for sqlserver now
> I saved my modifications to the maintenance plan...
> How do I manually test if this actually solved the problem?
> Best Regards
> Jeff
>
>
|||Right click on the maintanence plan and select Execute from the popup menu
and View History for that plan (by right clicking on it again...)
Ekrem nsoy
"Jeff" <donot@.spam.me> wrote in message
news:eDsSQBLQIHA.4584@.TK2MSFTNGP03.phx.gbl...
>I modifyed the Maintenance Plan -> selected the Maintenance plan I selected
>"Modify". then I opened the "Reporting and Logging" window and unchecked
>"Send report to an email recipient". Maybe the error was here... the agent
>operator set as recipient was an domain account which not exist anymore
> It's a long time since this domain account was removed - strange if caused
> problem for sqlserver now
> I saved my modifications to the maintenance plan...
> How do I manually test if this actually solved the problem?
> Best Regards
> Jeff
>
|||Hi
Did you try to execute the job or the maintenance plan? If you look at the
view history of the plan it may have something in for the last run, if it is
still running then it would be incomplete information.
John
"Jeff" wrote:

> I tryed to execute the maintenace plan, but it failed... the second time I
> tryed to execute it it gave me this error message:
> Execute Maintenance Plan
> An exception occured while executing a Transact-SQL statement or batch
> (Microsoft.SqlServer.ConnectInfo)
> SqlServerAgent Error: Request to run job backup_db (from <domain>\Jeff)
> refused because the job is already running from a request by User
> <domain>\Jeff (Microsft Sql Server, Error 22022)
> I'm not sure how the first error message was (I tryed to execute the
> maintenance plan twice)...
> strange if I should get an error that the job is already running...
> well, maybe it was caused by my user account, which not a member of the
> local administrator on that server, but I'm a member of the administrators
> in the domain
> any suggestions?
>
>
|||It fails because as the error message refers it's already running. You
should check the history for any detailed error messages about the running
job if there is any.
Ekrem nsoy
"Jeff" <donot@.spam.me> wrote in message
news:enncutLQIHA.5184@.TK2MSFTNGP05.phx.gbl...
>I tryed to execute the maintenace plan, but it failed... the second time I
>tryed to execute it it gave me this error message:
> Execute Maintenance Plan
> An exception occured while executing a Transact-SQL statement or batch
> (Microsoft.SqlServer.ConnectInfo)
> SqlServerAgent Error: Request to run job backup_db (from <domain>\Jeff)
> refused because the job is already running from a request by User
> <domain>\Jeff (Microsft Sql Server, Error 22022)
> I'm not sure how the first error message was (I tryed to execute the
> maintenance plan twice)...
> strange if I should get an error that the job is already running...
> well, maybe it was caused by my user account, which not a member of the
> local administrator on that server, but I'm a member of the administrators
> in the domain
> any suggestions?
>
sql

Backup - [WildPacket]

New on SQL. Running the BlackBerry DB on this SQL2000.
Within the SQL Enterprise Console I right click on the BESMgmt DB and then
click All tasks -> Backup DB -> in destination backup to it shows me the
location and a file named Backup4Aug04. I want to rename this file?
Second I see the 2 files with *.TRN and *.BAK which I know what these files
are.
The weird thing is along with these 2 files and Backup4Aug04 the date stamp
changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
am sure our DB is not that big.
I want to know what this Backup4Aug04 file is and what is it doing?
Advise please.
Thank you.WILDPACKET wrote:
> New on SQL. Running the BlackBerry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these files
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.
Sounds like you have a scheduled job running that is doing your backups
(this is a good thing), which would explain the transaction log backups
with date/time stamps. I would also say that this job is appending full
backups to Backup4Aug04 (thus the 12GB size) instead of overwriting each
time.
You can manually run a backup, as you're attempting to do, and can
safely remove Backup4Aug04 from the device list and add your own file.|||WILDPACKET,
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
You can remove it or add a new one that will be the new destination (if
selected).
> Second I see the 2 files with *.TRN and *.BAK which I know what these files
> are.
- .TRN transaction log backup
- .BAK database backup
> The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> am sure our DB is not that big.
If you select "Append to media", then every backup will be added and the
previous stay intact. If you select "Overwrite existing media", then the
media will be overwritten with the new backup and no previous will be
available.
AMB
"WILDPACKET" wrote:
> New on SQL. Running the BlackBerry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these files
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.|||Thank you all for your reply. I got it.
"Alejandro Mesa" wrote:
> WILDPACKET,
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> You can remove it or add a new one that will be the new destination (if
> selected).
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> - .TRN transaction log backup
> - .BAK database backup
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
> > New on SQL. Running the BlackBerry DB on this SQL2000.
> >
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> >
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> >
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> >
> > I want to know what this Backup4Aug04 file is and what is it doing?
> >
> > Advise please.
> >
> > Thank you.|||I am blowing away my SQL server because it is running on Win2000 server and I
want to install Win2003 and then reinstall SQL 2000. Is there a free
too/utility which can assist me in perfroming all the proper
documentation/configuration?
Thank you.
"Alejandro Mesa" wrote:
> WILDPACKET,
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> You can remove it or add a new one that will be the new destination (if
> selected).
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> - .TRN transaction log backup
> - .BAK database backup
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
> > New on SQL. Running the BlackBerry DB on this SQL2000.
> >
> > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > click All tasks -> Backup DB -> in destination backup to it shows me the
> > location and a file named Backup4Aug04. I want to rename this file?
> >
> > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > are.
> >
> > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > am sure our DB is not that big.
> >
> > I want to know what this Backup4Aug04 file is and what is it doing?
> >
> > Advise please.
> >
> > Thank you.|||See if this helps.
How to move databases between computers that are running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
AMB
"WILDPACKET" wrote:
> I am blowing away my SQL server because it is running on Win2000 server and I
> want to install Win2003 and then reinstall SQL 2000. Is there a free
> too/utility which can assist me in perfroming all the proper
> documentation/configuration?
> Thank you.
>
>
> "Alejandro Mesa" wrote:
> > WILDPACKET,
> >
> > > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > > click All tasks -> Backup DB -> in destination backup to it shows me the
> > > location and a file named Backup4Aug04. I want to rename this file?
> >
> > You can remove it or add a new one that will be the new destination (if
> > selected).
> >
> > > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > > are.
> >
> > - .TRN transaction log backup
> > - .BAK database backup
> >
> > > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > > am sure our DB is not that big.
> >
> > If you select "Append to media", then every backup will be added and the
> > previous stay intact. If you select "Overwrite existing media", then the
> > media will be overwritten with the new backup and no previous will be
> > available.
> >
> >
> > AMB
> >
> > "WILDPACKET" wrote:
> >
> > > New on SQL. Running the BlackBerry DB on this SQL2000.
> > >
> > > Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> > > click All tasks -> Backup DB -> in destination backup to it shows me the
> > > location and a file named Backup4Aug04. I want to rename this file?
> > >
> > > Second I see the 2 files with *.TRN and *.BAK which I know what these files
> > > are.
> > >
> > > The weird thing is along with these 2 files and Backup4Aug04 the date stamp
> > > changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
> > > am sure our DB is not that big.
> > >
> > > I want to know what this Backup4Aug04 file is and what is it doing?
> > >
> > > Advise please.
> > >
> > > Thank you.

Backup - [WildPacket]

WILDPACKET wrote:
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.
Sounds like you have a scheduled job running that is doing your backups
(this is a good thing), which would explain the transaction log backups
with date/time stamps. I would also say that this job is appending full
backups to Backup4Aug04 (thus the 12GB size) instead of overwriting each
time.
You can manually run a backup, as you're attempting to do, and can
safely remove Backup4Aug04 from the device list and add your own file.WILDPACKET,

> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
You can remove it or add a new one that will be the new destination (if
selected).

> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
- .TRN transaction log backup
- .BAK database backup

> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
If you select "Append to media", then every backup will be added and the
previous stay intact. If you select "Overwrite existing media", then the
media will be overwritten with the new backup and no previous will be
available.
AMB
"WILDPACKET" wrote:

> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.|||Thank you all for your reply. I got it.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>|||I am blowing away my SQL server because it is running on Win2000 server and
I
want to install Win2003 and then reinstall SQL 2000. Is there a free
too/utility which can assist me in perfroming all the proper
documentation/configuration?
Thank you.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>|||See if this helps.
How to move databases between computers that are running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
AMB
"WILDPACKET" wrote:
[vbcol=seagreen]
> I am blowing away my SQL server because it is running on Win2000 server an
d I
> want to install Win2003 and then reinstall SQL 2000. Is there a free
> too/utility which can assist me in perfroming all the proper
> documentation/configuration?
> Thank you.
>
>
> "Alejandro Mesa" wrote:
>|||New on SQL. Running the blackberry DB on this SQL2000.
Within the SQL Enterprise Console I right click on the BESMgmt DB and then
click All tasks -> Backup DB -> in destination backup to it shows me the
location and a file named Backup4Aug04. I want to rename this file?
Second I see the 2 files with *.TRN and *.BAK which I know what these files
are.
The weird thing is along with these 2 files and Backup4Aug04 the date stamp
changes to the current date daily. and the Backup4Aug04 is like 12 GB and I
am sure our DB is not that big.
I want to know what this Backup4Aug04 file is and what is it doing?
Advise please.
Thank you.|||WILDPACKET wrote:
> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.
Sounds like you have a scheduled job running that is doing your backups
(this is a good thing), which would explain the transaction log backups
with date/time stamps. I would also say that this job is appending full
backups to Backup4Aug04 (thus the 12GB size) instead of overwriting each
time.
You can manually run a backup, as you're attempting to do, and can
safely remove Backup4Aug04 from the device list and add your own file.|||WILDPACKET,

> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
You can remove it or add a new one that will be the new destination (if
selected).

> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
- .TRN transaction log backup
- .BAK database backup

> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
If you select "Append to media", then every backup will be added and the
previous stay intact. If you select "Overwrite existing media", then the
media will be overwritten with the new backup and no previous will be
available.
AMB
"WILDPACKET" wrote:

> New on SQL. Running the blackberry DB on this SQL2000.
> Within the SQL Enterprise Console I right click on the BESMgmt DB and then
> click All tasks -> Backup DB -> in destination backup to it shows me the
> location and a file named Backup4Aug04. I want to rename this file?
> Second I see the 2 files with *.TRN and *.BAK which I know what these file
s
> are.
> The weird thing is along with these 2 files and Backup4Aug04 the date stam
p
> changes to the current date daily. and the Backup4Aug04 is like 12 GB and
I
> am sure our DB is not that big.
> I want to know what this Backup4Aug04 file is and what is it doing?
> Advise please.
> Thank you.|||Thank you all for your reply. I got it.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>|||I am blowing away my SQL server because it is running on Win2000 server and
I
want to install Win2003 and then reinstall SQL 2000. Is there a free
too/utility which can assist me in perfroming all the proper
documentation/configuration?
Thank you.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> WILDPACKET,
>
> You can remove it or add a new one that will be the new destination (if
> selected).
>
> - .TRN transaction log backup
> - .BAK database backup
>
> If you select "Append to media", then every backup will be added and the
> previous stay intact. If you select "Overwrite existing media", then the
> media will be overwritten with the new backup and no previous will be
> available.
>
> AMB
> "WILDPACKET" wrote:
>