Backup Failed to complete command SP_EXECUTESQL;1

hi,
in my event log I have the alarm Backup failed to complete command
sp_executesql;1
The point is that I didn't find any scheduled backup jobs and I didn't find
any *.bak file relative to the DB mentioned in the alarm. (I can see the DB
file name in the text window at the bottom of the detail in Windows event
log )
I suspect that it's hidden in a stored procedure or somewhere else. How can
I find it?
I have two DB on the system pointed by this alarm and they're quite large 20
& 25gig so if a backup file was create I think I wouldn't have difficulty
to find them.
I didn't find any infos on the net about this alarm so if someone can give
me some the help me to search deeper.
Regards
MarcDo you have any third party products installed on the server, that perform
database backups? Worth checking under Start > Programs
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"marc quirion" <mquirion@.videotron.ca> wrote in message
news:SfKFe.92489$mv2.1552703@.weber.videotron.net...
hi,
in my event log I have the alarm Backup failed to complete command
sp_executesql;1
The point is that I didn't find any scheduled backup jobs and I didn't find
any *.bak file relative to the DB mentioned in the alarm. (I can see the DB
file name in the text window at the bottom of the detail in Windows event
log )
I suspect that it's hidden in a stored procedure or somewhere else. How can
I find it?
I have two DB on the system pointed by this alarm and they're quite large 20
& 25gig so if a backup file was create I think I wouldn't have difficulty
to find them.
I didn't find any infos on the net about this alarm so if someone can give
me some the help me to search deeper.
Regards
Marc

BACKUP ERRORS MISSING IN THE EVENT LOG

Hi,

One of our backup jobs failed this morning but nothing got written into
win nt application event log. This way our MOM 2005 couldn't generate
an alert on this event since mom inspetcs application event log for
that purpose (event id 17055). I see backup errors about 10 days ago in
the appl log. What could have caused that? Any help will be
appreciated.

Stan(suslikovich@.yahoo.com) writes:
> One of our backup jobs failed this morning but nothing got written into
> win nt application event log. This way our MOM 2005 couldn't generate
> an alert on this event since mom inspetcs application event log for
> that purpose (event id 17055). I see backup errors about 10 days ago in
> the appl log. What could have caused that? Any help will be
> appreciated.

Do you see anything in the SQL Server error log?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.aspsql

Backup DTS and Jobs

Hi!
When I backup my database, how can I include DTS and Jobs?
Thanks!
/Tom Hansen
> When I backup my database, how can I include DTS and Jobs?
Jobs are in msdb daabase. If you save DTS packages to SQL Server, they are
in the msdb database as well. So simply backup the msdb database.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Thanks a lot!!
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:OJbtN4LwEHA.1300@.TK2MSFTNGP14.phx.gbl...
> Jobs are in msdb daabase. If you save DTS packages to SQL Server, they are
> in the msdb database as well. So simply backup the msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>

Backup DTS and Jobs

Hi!
When I backup my database, how can I include DTS and Jobs?
Thanks!
/Tom Hansen> When I backup my database, how can I include DTS and Jobs?
Jobs are in msdb daabase. If you save DTS packages to SQL Server, they are
in the msdb database as well. So simply backup the msdb database.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thanks a lot!!
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OJbtN4LwEHA.1300@.TK2MSFTNGP14.phx.gbl...
> Jobs are in msdb daabase. If you save DTS packages to SQL Server, they are
> in the msdb database as well. So simply backup the msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>

Backup DTS and Jobs

Hi!
When I backup my database, how can I include DTS and Jobs?
Thanks!
/Tom Hansen> When I backup my database, how can I include DTS and Jobs?
Jobs are in msdb daabase. If you save DTS packages to SQL Server, they are
in the msdb database as well. So simply backup the msdb database.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thanks a lot!!
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OJbtN4LwEHA.1300@.TK2MSFTNGP14.phx.gbl...
>> When I backup my database, how can I include DTS and Jobs?
> Jobs are in msdb daabase. If you save DTS packages to SQL Server, they are
> in the msdb database as well. So simply backup the msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>

Backup display

I created some backups for my databases and they show in the Enterprise Jobs
as Uncategorized [local]. All the Maintenance Plans show as Database
Maintenance.
I have about 10 of them and you can't tell which is which without going into
the properties.
Is there an easier way to see what backups you have set up and what the
status is?
Thanks,
TomI am not quite sure what you are asking. You have the ability to put what
ever description you want for any job. You also have the ability to set the
category or to even create a new custom category. So between those two
options you should certainly be able to do something descriptive enough to
group your jobs appropriately.
--
Andrew J. Kelly SQL MVP
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:%232QEfvx5FHA.884@.TK2MSFTNGP14.phx.gbl...
>I created some backups for my databases and they show in the Enterprise
>Jobs as Uncategorized [local]. All the Maintenance Plans show as Database
>Maintenance.
> I have about 10 of them and you can't tell which is which without going
> into the properties.
> Is there an easier way to see what backups you have set up and what the
> status is?
> Thanks,
> Tom
>

Backup

How do you back up the Agent Jobs and the Local Packages under Data
Transformation services? Does this get backed up when you back up the Master
database?
Thanks
RickThey get backed up when you backup the msdb database.
-Sue
On Wed, 13 Aug 2003 15:14:27 -0700, "Rick V"
<rick@.di-wave.com> wrote:
>How do you back up the Agent Jobs and the Local Packages under Data
>Transformation services? Does this get backed up when you back up the Master
>database?
> Thanks
> Rick
>|||Thanks very much!!!
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:9ngljvsocne65i7n5lsftphqpddsqs579u@.4ax.com...
> They get backed up when you backup the msdb database.
> -Sue
> On Wed, 13 Aug 2003 15:14:27 -0700, "Rick V"
> <rick@.di-wave.com> wrote:
> >How do you back up the Agent Jobs and the Local Packages under Data
> >Transformation services? Does this get backed up when you back up the
Master
> >database?
> >
> > Thanks
> > Rick
> >
>