MAPI email service for SQL 7.0

Hello,
We recently set up our SQL 7.0 server (on Win2k) to email us on
different things (mainly results for Database Maintenance Plans). We
went through the process of installing Outlook and configuring SQL to
use its MAPI profile, etc., and it works fine. But my question is, is
there an alternative to using Outlook? I know there's Netscape and
Eudora, but an ideal solution would be a lightweight app that would
run as a service, that would send mail for its MAPI profile. Does
such a thing exist? The current setup works but is kind of
cumbersome. Sending email by SMTP would be even better, but so far we
haven't found anything that can do that, either, that interfaces with
SQL server's Maintenance Plans, etc.
Thanks for all feedback.
--
Chris> cumbersome. Sending email by SMTP would be even better, but so far we
> haven't found anything that can do that, either, that interfaces with
> SQL server's Maintenance Plans, etc.
http://www.aspfaq.com/2403
Not sure why xp_smtp_sendmail would be discarded simply because it doesn't
interface directly with maintenance plans (how often are you modifying these
in such a way that however you set them up will change?). What I do is
manually add a step to the job, which calls xp_smtp_sendmail (among other
things), and make that the last step. Previous steps move to the last step
on error. And the last step before the sendmail step just completes on
success, and moves to the "last" step on failure.|||Forget the SQL Server built in MAPI. It stinks and has a bunch of security
holes. Plus, it's hard to configure.
If you want to simply send e-mail from SQL Server using SMTP, download this
little gem. Simply copy the .DLL to your binary directory, registry the
X_SP and you're off.
Add "smarthost" to your hosts file if you wish to have it use the default IP
from here. Otherwise, you'll have to pass it the TCP/IP of your mail
server as a parameter. This has built in SMTP Agent.
http://www.sqldev.net/xp/xpsmtp.htm
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > cumbersome. Sending email by SMTP would be even better, but so far we
> > haven't found anything that can do that, either, that interfaces with
> > SQL server's Maintenance Plans, etc.
> http://www.aspfaq.com/2403
> Not sure why xp_smtp_sendmail would be discarded simply because it doesn't
> interface directly with maintenance plans (how often are you modifying
these
> in such a way that however you set them up will change?). What I do is
> manually add a step to the job, which calls xp_smtp_sendmail (among other
> things), and make that the last step. Previous steps move to the last
step
> on error. And the last step before the sendmail step just completes on
> success, and moves to the "last" step on failure.
>|||Thanks for all of the input. I have downloaded & installed XPSMTP and
it works great. The reason I originally inquired about easy interface
with Maintenance Plans was for other uses to easily create/modify new
Maintenance plans, and set up email easily.
Thanks again,
--
Chris
"David M" <scandal123@.cox.net> wrote in message news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> Forget the SQL Server built in MAPI. It stinks and has a bunch of security
> holes. Plus, it's hard to configure.
> If you want to simply send e-mail from SQL Server using SMTP, download this
> little gem. Simply copy the .DLL to your binary directory, registry the
> X_SP and you're off.
> Add "smarthost" to your hosts file if you wish to have it use the default IP
> from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> server as a parameter. This has built in SMTP Agent.
> http://www.sqldev.net/xp/xpsmtp.htm
>
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > cumbersome. Sending email by SMTP would be even better, but so far we
> > > haven't found anything that can do that, either, that interfaces with
> > > SQL server's Maintenance Plans, etc.
> >
> > http://www.aspfaq.com/2403
> >
> > Not sure why xp_smtp_sendmail would be discarded simply because it doesn't
> > interface directly with maintenance plans (how often are you modifying
> these
> > in such a way that however you set them up will change?). What I do is
> > manually add a step to the job, which calls xp_smtp_sendmail (among other
> > things), and make that the last step. Previous steps move to the last
> step
> > on error. And the last step before the sendmail step just completes on
> > success, and moves to the "last" step on failure.
> >
> >|||Is there any concern for the stability of the xpsmtp extended proc since it
runs in the same memory space as sql server?
"Chris Szilagyi" <chris@.groupinfo.com> wrote in message
news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> Thanks for all of the input. I have downloaded & installed XPSMTP and
> it works great. The reason I originally inquired about easy interface
> with Maintenance Plans was for other uses to easily create/modify new
> Maintenance plans, and set up email easily.
> Thanks again,
> --
> Chris
> "David M" <scandal123@.cox.net> wrote in message
news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > Forget the SQL Server built in MAPI. It stinks and has a bunch of
security
> > holes. Plus, it's hard to configure.
> >
> > If you want to simply send e-mail from SQL Server using SMTP, download
this
> > little gem. Simply copy the .DLL to your binary directory, registry the
> > X_SP and you're off.
> >
> > Add "smarthost" to your hosts file if you wish to have it use the
default IP
> > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > server as a parameter. This has built in SMTP Agent.
> >
> > http://www.sqldev.net/xp/xpsmtp.htm
> >
> >
> >
> > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > cumbersome. Sending email by SMTP would be even better, but so far
we
> > > > haven't found anything that can do that, either, that interfaces
with
> > > > SQL server's Maintenance Plans, etc.
> > >
> > > http://www.aspfaq.com/2403
> > >
> > > Not sure why xp_smtp_sendmail would be discarded simply because it
doesn't
> > > interface directly with maintenance plans (how often are you modifying
> > these
> > > in such a way that however you set them up will change?). What I do
is
> > > manually add a step to the job, which calls xp_smtp_sendmail (among
other
> > > things), and make that the last step. Previous steps move to the last
> > step
> > > on error. And the last step before the sendmail step just completes
on
> > > success, and moves to the "last" step on failure.
> > >
> > >|||Is there any concern about the stability of this extended proc since it runs
in the same mem space as sqlserver
"Chris Szilagyi" <chris@.groupinfo.com> wrote in message
news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> Thanks for all of the input. I have downloaded & installed XPSMTP and
> it works great. The reason I originally inquired about easy interface
> with Maintenance Plans was for other uses to easily create/modify new
> Maintenance plans, and set up email easily.
> Thanks again,
> --
> Chris
> "David M" <scandal123@.cox.net> wrote in message
news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > Forget the SQL Server built in MAPI. It stinks and has a bunch of
security
> > holes. Plus, it's hard to configure.
> >
> > If you want to simply send e-mail from SQL Server using SMTP, download
this
> > little gem. Simply copy the .DLL to your binary directory, registry the
> > X_SP and you're off.
> >
> > Add "smarthost" to your hosts file if you wish to have it use the
default IP
> > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > server as a parameter. This has built in SMTP Agent.
> >
> > http://www.sqldev.net/xp/xpsmtp.htm
> >
> >
> >
> > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > cumbersome. Sending email by SMTP would be even better, but so far
we
> > > > haven't found anything that can do that, either, that interfaces
with
> > > > SQL server's Maintenance Plans, etc.
> > >
> > > http://www.aspfaq.com/2403
> > >
> > > Not sure why xp_smtp_sendmail would be discarded simply because it
doesn't
> > > interface directly with maintenance plans (how often are you modifying
> > these
> > > in such a way that however you set them up will change?). What I do
is
> > > manually add a step to the job, which calls xp_smtp_sendmail (among
other
> > > things), and make that the last step. Previous steps move to the last
> > step
> > > on error. And the last step before the sendmail step just completes
on
> > > success, and moves to the "last" step on failure.
> > >
> > >|||I use it extensively in mission critical apps and have yet to notice any
issues whatsoever.
"Rohan Balraj" <rohanbalraj@.bellsouth.net> wrote in message
news:wsGnb.77882$W77.8168@.bignews6.bellsouth.net...
> Is there any concern for the stability of the xpsmtp extended proc since
it
> runs in the same memory space as sql server?|||> Is there any concern for the stability of the xpsmtp extended proc since it
> runs in the same memory space as sql server?
The same applies for xp_sendmail. It is also an extended stored procedure. Personally, I have the
greatest confidence in the developer of xp_smtp_sendmail.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rohan Balraj" <rohanbalraj@.bellsouth.net> wrote in message
news:wsGnb.77882$W77.8168@.bignews6.bellsouth.net...
> Is there any concern for the stability of the xpsmtp extended proc since it
> runs in the same memory space as sql server?
> "Chris Szilagyi" <chris@.groupinfo.com> wrote in message
> news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> > Thanks for all of the input. I have downloaded & installed XPSMTP and
> > it works great. The reason I originally inquired about easy interface
> > with Maintenance Plans was for other uses to easily create/modify new
> > Maintenance plans, and set up email easily.
> >
> > Thanks again,
> > --
> > Chris
> >
> > "David M" <scandal123@.cox.net> wrote in message
> news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > > Forget the SQL Server built in MAPI. It stinks and has a bunch of
> security
> > > holes. Plus, it's hard to configure.
> > >
> > > If you want to simply send e-mail from SQL Server using SMTP, download
> this
> > > little gem. Simply copy the .DLL to your binary directory, registry the
> > > X_SP and you're off.
> > >
> > > Add "smarthost" to your hosts file if you wish to have it use the
> default IP
> > > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > > server as a parameter. This has built in SMTP Agent.
> > >
> > > http://www.sqldev.net/xp/xpsmtp.htm
> > >
> > >
> > >
> > > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > > cumbersome. Sending email by SMTP would be even better, but so far
> we
> > > > > haven't found anything that can do that, either, that interfaces
> with
> > > > > SQL server's Maintenance Plans, etc.
> > > >
> > > > http://www.aspfaq.com/2403
> > > >
> > > > Not sure why xp_smtp_sendmail would be discarded simply because it
> doesn't
> > > > interface directly with maintenance plans (how often are you modifying
> > > these
> > > > in such a way that however you set them up will change?). What I do
> is
> > > > manually add a step to the job, which calls xp_smtp_sendmail (among
> other
> > > > things), and make that the last step. Previous steps move to the last
> > > step
> > > > on error. And the last step before the sendmail step just completes
> on
> > > > success, and moves to the "last" step on failure.
> > > >
> > > >
>|||It's a shame that something that seems so trivial wasn't done by Microsoft.
Something like XPSMTP originally instead of xp_sendmail would have made
things much more easier for SQL Admins--especially when only needing to send
outgoing mail from SQL Server. Who knows -- maybe Yukon will have a few
surprises...
"Rohan Balraj" <rohanbalraj@.bellsouth.net> wrote in message
news:ItGnb.77890$W77.37198@.bignews6.bellsouth.net...
> Is there any concern about the stability of this extended proc since it
runs
> in the same mem space as sqlserver
> "Chris Szilagyi" <chris@.groupinfo.com> wrote in message
> news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> > Thanks for all of the input. I have downloaded & installed XPSMTP and
> > it works great. The reason I originally inquired about easy interface
> > with Maintenance Plans was for other uses to easily create/modify new
> > Maintenance plans, and set up email easily.
> >
> > Thanks again,
> > --
> > Chris
> >
> > "David M" <scandal123@.cox.net> wrote in message
> news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > > Forget the SQL Server built in MAPI. It stinks and has a bunch of
> security
> > > holes. Plus, it's hard to configure.
> > >
> > > If you want to simply send e-mail from SQL Server using SMTP, download
> this
> > > little gem. Simply copy the .DLL to your binary directory, registry
the
> > > X_SP and you're off.
> > >
> > > Add "smarthost" to your hosts file if you wish to have it use the
> default IP
> > > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > > server as a parameter. This has built in SMTP Agent.
> > >
> > > http://www.sqldev.net/xp/xpsmtp.htm
> > >
> > >
> > >
> > > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > > cumbersome. Sending email by SMTP would be even better, but so
far
> we
> > > > > haven't found anything that can do that, either, that interfaces
> with
> > > > > SQL server's Maintenance Plans, etc.
> > > >
> > > > http://www.aspfaq.com/2403
> > > >
> > > > Not sure why xp_smtp_sendmail would be discarded simply because it
> doesn't
> > > > interface directly with maintenance plans (how often are you
modifying
> > > these
> > > > in such a way that however you set them up will change?). What I do
> is
> > > > manually add a step to the job, which calls xp_smtp_sendmail (among
> other
> > > > things), and make that the last step. Previous steps move to the
last
> > > step
> > > > on error. And the last step before the sendmail step just completes
> on
> > > > success, and moves to the "last" step on failure.
> > > >
> > > >
>|||> Who knows -- maybe Yukon will have a few surprises...
There has been a bit of rumbling about (and definitely a lot of screaming
and begging for) a new e-mail system, but it's way too early to tell if it
will be implemented at all, and if so, whether it will make it into Yukon,
or Yukon + 1, or Yukon + n... never mind what it will look like, and whether
it will support SMTP and POP3, or just SMTP, etc. As you said, maybe there
will be a few surprises... we'll have to wait for subsequent bits, I
suppose. :-)

many problems, fixed?

Hi All-
SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
there, but corruption has been in the maintenance plan log for over a year.
I made backup of db and restored as different name on different disk array.
I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
CHECKDB with repair_rebuild option. This corrected some errors, now I am
down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors. I
have compared row count on corrupt tables before and after the data_loss
option ran and my row count is the same before and after.
What else do I need to look at to see what data was loss with the
repair_data_loss option?
After ths is correct I will be working with the owner and app vendor to get
the sql and os at least patched to current levels if not upgraded.
Thanks!
I suppose you could check the size of the database and the number of indexes
in it. It doesn't sound like you have much of a choice but to go with the
repaired database anyway.
Good luck...
Ben
"Ryan Sanders" <rsanders> wrote in message
news:108nd8uapvjvbb2@.corp.supernews.com...
> Hi All-
>
> SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
> there, but corruption has been in the maintenance plan log for over a
year.
> I made backup of db and restored as different name on different disk
array.
> I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
> next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
> CHECKDB with repair_rebuild option. This corrected some errors, now I am
> down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
> repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors.
I
> have compared row count on corrupt tables before and after the data_loss
> option ran and my row count is the same before and after.
>
> What else do I need to look at to see what data was loss with the
> repair_data_loss option?
>
> After ths is correct I will be working with the owner and app vendor to
get
> the sql and os at least patched to current levels if not upgraded.
>
> Thanks!
>
|||Can anyone provide any guidance?
Thanks!
Ryan
"Ryan Sanders" <rsanders> wrote in message news:<108nd8uapvjvbb2@.corp.supernews.com>...
> Hi All-
>
> SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
> there, but corruption has been in the maintenance plan log for over a year.
> I made backup of db and restored as different name on different disk array.
> I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
> next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
> CHECKDB with repair_rebuild option. This corrected some errors, now I am
> down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
> repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors. I
> have compared row count on corrupt tables before and after the data_loss
> option ran and my row count is the same before and after.
>
> What else do I need to look at to see what data was loss with the
> repair_data_loss option?
>
> After ths is correct I will be working with the owner and app vendor to get
> the sql and os at least patched to current levels if not upgraded.
>
> Thanks!

many problems, fixed?

Hi All-
SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
there, but corruption has been in the maintenance plan log for over a year.
I made backup of db and restored as different name on different disk array.
I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
CHECKDB with repair_rebuild option. This corrected some errors, now I am
down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors. I
have compared row count on corrupt tables before and after the data_loss
option ran and my row count is the same before and after.
What else do I need to look at to see what data was loss with the
repair_data_loss option?
After ths is correct I will be working with the owner and app vendor to get
the sql and os at least patched to current levels if not upgraded.
Thanks!I suppose you could check the size of the database and the number of indexes
in it. It doesn't sound like you have much of a choice but to go with the
repaired database anyway.
Good luck...
Ben
"Ryan Sanders" <rsanders> wrote in message
news:108nd8uapvjvbb2@.corp.supernews.com...
> Hi All-
>
> SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
> there, but corruption has been in the maintenance plan log for over a
year.
> I made backup of db and restored as different name on different disk
array.
> I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
> next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
> CHECKDB with repair_rebuild option. This corrected some errors, now I am
> down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
> repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors.
I
> have compared row count on corrupt tables before and after the data_loss
> option ran and my row count is the same before and after.
>
> What else do I need to look at to see what data was loss with the
> repair_data_loss option?
>
> After ths is correct I will be working with the owner and app vendor to
get
> the sql and os at least patched to current levels if not upgraded.
>
> Thanks!
>|||Can anyone provide any guidance?
Thanks!
Ryan
"Ryan Sanders" <rsanders> wrote in message news:<108nd8uapvjvbb2@.corp.supernews.com>...
> Hi All-
>
> SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
> there, but corruption has been in the maintenance plan log for over a year.
> I made backup of db and restored as different name on different disk array.
> I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
> next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
> CHECKDB with repair_rebuild option. This corrected some errors, now I am
> down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
> repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors. I
> have compared row count on corrupt tables before and after the data_loss
> option ran and my row count is the same before and after.
>
> What else do I need to look at to see what data was loss with the
> repair_data_loss option?
>
> After ths is correct I will be working with the owner and app vendor to get
> the sql and os at least patched to current levels if not upgraded.
>
> Thanks!

many problems, fixed?

Hi All-
SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
there, but corruption has been in the maintenance plan log for over a year.
I made backup of db and restored as different name on different disk array.
I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
CHECKDB with repair_rebuild option. This corrected some errors, now I am
down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors. I
have compared row count on corrupt tables before and after the data_loss
option ran and my row count is the same before and after.
What else do I need to look at to see what data was loss with the
repair_data_loss option?
After ths is correct I will be working with the owner and app vendor to get
the sql and os at least patched to current levels if not upgraded.
Thanks!I suppose you could check the size of the database and the number of indexes
in it. It doesn't sound like you have much of a choice but to go with the
repaired database anyway.
Good luck...
Ben
"Ryan Sanders" <rsanders> wrote in message
news:108nd8uapvjvbb2@.corp.supernews.com...
> Hi All-
>
> SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
> there, but corruption has been in the maintenance plan log for over a
year.
> I made backup of db and restored as different name on different disk
array.
> I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
> next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
> CHECKDB with repair_rebuild option. This corrected some errors, now I am
> down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
> repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors.
I
> have compared row count on corrupt tables before and after the data_loss
> option ran and my row count is the same before and after.
>
> What else do I need to look at to see what data was loss with the
> repair_data_loss option?
>
> After ths is correct I will be working with the owner and app vendor to
get
> the sql and os at least patched to current levels if not upgraded.
>
> Thanks!
>|||Can anyone provide any guidance?
Thanks!
Ryan
"Ryan Sanders" <rsanders> wrote in message news:<108nd8uapvjvbb2@.corp.supernews.com>...[vbco
l=seagreen]
> Hi All-
>
> SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
> there, but corruption has been in the maintenance plan log for over a year
.
> I made backup of db and restored as different name on different disk array
.
> I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
> next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
> CHECKDB with repair_rebuild option. This corrected some errors, now I am
> down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
> repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors.
I
> have compared row count on corrupt tables before and after the data_loss
> option ran and my row count is the same before and after.
>
> What else do I need to look at to see what data was loss with the
> repair_data_loss option?
>
> After ths is correct I will be working with the owner and app vendor to ge
t
> the sql and os at least patched to current levels if not upgraded.
>
> Thanks![/vbcol]

Manintenance Plan

I've created a maintenance plan and getting the following error message in the event log. This has been working for a while problem happend a week a ago, no changes to the system. Novice SQL user, any help on this appreciated.

Event ID 208. SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'RSS Pro2000 DBMP'' (0xFE3D7C9C154F9E48A4AA953C88D9F97E) - Status: Failed - Invoked on: 2007-03-19 13:28:00 - Message: The job failed. The Job was invoked by Schedule 13 (Schedule 1). The last step to run was step 1 (Step 1).

Are there any changes to the recovery model during this time of execution?

Also check the password or any information pertaining to SQLAgent account used here.

http://www.sqlservercentral.com/columnists/aingold/workingaround2005maintenanceplans.asp fyi.

|||No changes made. SQLAgent using 'Local System' a/c|||

Try to execute the job as manually with your account credential.

Do you have any other databases scheduled in this database?

if so are they getting same error?

|||The Db's are being backed up (there's 4 in total). It's only the transaction log that are not running.I've changed the a/c to 'administrator' and ran another transaction log and getting the same message.|||Have you applied the service pack or any changes to the server recentlY?

Managing backup files using SQL Agent

My client has about 3 servers with several databases on each. These databases
are backed up to disk using maintenance plans. This client wants to copy SQL
backup files on the disks of these servers to an additional server with a
tape drive to do consolidated backup to tape.
Is the best way to copy backup files already on disk to a network share to
use a DOS copy command through SQL Agent?
If so, is it best to run SQL Agent using a domain account with substantial
rights to ensure that SQL agent has appropriate file permissions both locally
and on network paths? When SQL agent runs under the local system account,
file copy operations fail with "Access denied" messages.
Does anyone have suggestions on how to do this task?
Larry Menzin
American Techsystems Corp.
I run my SQL Agent using a Domain User account that is local administrator
on the server.
In your case, just add a step to the jobs that the maintenance plans created
that calls XP_Cmdshell to do a DOS copy of the files after the backup is
complete.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Larry Menzin" <LarryMenzin@.discussions.microsoft.com> wrote in message
news:B52A63D9-A817-430C-9B0F-17139F121FBC@.microsoft.com...
> My client has about 3 servers with several databases on each. These
> databases
> are backed up to disk using maintenance plans. This client wants to copy
> SQL
> backup files on the disks of these servers to an additional server with a
> tape drive to do consolidated backup to tape.
> Is the best way to copy backup files already on disk to a network share to
> use a DOS copy command through SQL Agent?
> If so, is it best to run SQL Agent using a domain account with substantial
> rights to ensure that SQL agent has appropriate file permissions both
> locally
> and on network paths? When SQL agent runs under the local system account,
> file copy operations fail with "Access denied" messages.
> Does anyone have suggestions on how to do this task?
> --
> Larry Menzin
> American Techsystems Corp.
|||Hi
Do it as a OperatingSystemCommand (cmdExec) in SQL Agent.
Something like:
xcopy *.bak \\servername\sharename\*.* /E /Y
SQL Server has to use a domain account to run under, otherwise it does not
have a way to authenticate itself with the other server.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Menzin" <LarryMenzin@.discussions.microsoft.com> wrote in message
news:B52A63D9-A817-430C-9B0F-17139F121FBC@.microsoft.com...
> My client has about 3 servers with several databases on each. These
> databases
> are backed up to disk using maintenance plans. This client wants to copy
> SQL
> backup files on the disks of these servers to an additional server with a
> tape drive to do consolidated backup to tape.
> Is the best way to copy backup files already on disk to a network share to
> use a DOS copy command through SQL Agent?
> If so, is it best to run SQL Agent using a domain account with substantial
> rights to ensure that SQL agent has appropriate file permissions both
> locally
> and on network paths? When SQL agent runs under the local system account,
> file copy operations fail with "Access denied" messages.
> Does anyone have suggestions on how to do this task?
> --
> Larry Menzin
> American Techsystems Corp.

Managing backup files using SQL Agent

My client has about 3 servers with several databases on each. These database
s
are backed up to disk using maintenance plans. This client wants to copy SQL
backup files on the disks of these servers to an additional server with a
tape drive to do consolidated backup to tape.
Is the best way to copy backup files already on disk to a network share to
use a DOS copy command through SQL Agent?
If so, is it best to run SQL Agent using a domain account with substantial
rights to ensure that SQL agent has appropriate file permissions both locall
y
and on network paths? When SQL agent runs under the local system account,
file copy operations fail with "Access denied" messages.
Does anyone have suggestions on how to do this task?
Larry Menzin
American Techsystems Corp.I run my SQL Agent using a Domain User account that is local administrator
on the server.
In your case, just add a step to the jobs that the maintenance plans created
that calls XP_Cmdshell to do a DOS copy of the files after the backup is
complete.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Larry Menzin" <LarryMenzin@.discussions.microsoft.com> wrote in message
news:B52A63D9-A817-430C-9B0F-17139F121FBC@.microsoft.com...
> My client has about 3 servers with several databases on each. These
> databases
> are backed up to disk using maintenance plans. This client wants to copy
> SQL
> backup files on the disks of these servers to an additional server with a
> tape drive to do consolidated backup to tape.
> Is the best way to copy backup files already on disk to a network share to
> use a DOS copy command through SQL Agent?
> If so, is it best to run SQL Agent using a domain account with substantial
> rights to ensure that SQL agent has appropriate file permissions both
> locally
> and on network paths? When SQL agent runs under the local system account,
> file copy operations fail with "Access denied" messages.
> Does anyone have suggestions on how to do this task?
> --
> Larry Menzin
> American Techsystems Corp.|||Hi
Do it as a OperatingSystemCommand (cmdExec) in SQL Agent.
Something like:
xcopy *.bak \\servername\sharename\*.* /E /Y
SQL Server has to use a domain account to run under, otherwise it does not
have a way to authenticate itself with the other server.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Menzin" <LarryMenzin@.discussions.microsoft.com> wrote in message
news:B52A63D9-A817-430C-9B0F-17139F121FBC@.microsoft.com...
> My client has about 3 servers with several databases on each. These
> databases
> are backed up to disk using maintenance plans. This client wants to copy
> SQL
> backup files on the disks of these servers to an additional server with a
> tape drive to do consolidated backup to tape.
> Is the best way to copy backup files already on disk to a network share to
> use a DOS copy command through SQL Agent?
> If so, is it best to run SQL Agent using a domain account with substantial
> rights to ensure that SQL agent has appropriate file permissions both
> locally
> and on network paths? When SQL agent runs under the local system account,
> file copy operations fail with "Access denied" messages.
> Does anyone have suggestions on how to do this task?
> --
> Larry Menzin
> American Techsystems Corp.

Managing backup files using SQL Agent

My client has about 3 servers with several databases on each. These databases
are backed up to disk using maintenance plans. This client wants to copy SQL
backup files on the disks of these servers to an additional server with a
tape drive to do consolidated backup to tape.
Is the best way to copy backup files already on disk to a network share to
use a DOS copy command through SQL Agent?
If so, is it best to run SQL Agent using a domain account with substantial
rights to ensure that SQL agent has appropriate file permissions both locally
and on network paths? When SQL agent runs under the local system account,
file copy operations fail with "Access denied" messages.
Does anyone have suggestions on how to do this task?
--
Larry Menzin
American Techsystems Corp.I run my SQL Agent using a Domain User account that is local administrator
on the server.
In your case, just add a step to the jobs that the maintenance plans created
that calls XP_Cmdshell to do a DOS copy of the files after the backup is
complete.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Larry Menzin" <LarryMenzin@.discussions.microsoft.com> wrote in message
news:B52A63D9-A817-430C-9B0F-17139F121FBC@.microsoft.com...
> My client has about 3 servers with several databases on each. These
> databases
> are backed up to disk using maintenance plans. This client wants to copy
> SQL
> backup files on the disks of these servers to an additional server with a
> tape drive to do consolidated backup to tape.
> Is the best way to copy backup files already on disk to a network share to
> use a DOS copy command through SQL Agent?
> If so, is it best to run SQL Agent using a domain account with substantial
> rights to ensure that SQL agent has appropriate file permissions both
> locally
> and on network paths? When SQL agent runs under the local system account,
> file copy operations fail with "Access denied" messages.
> Does anyone have suggestions on how to do this task?
> --
> Larry Menzin
> American Techsystems Corp.|||Hi
Do it as a OperatingSystemCommand (cmdExec) in SQL Agent.
Something like:
xcopy *.bak \\servername\sharename\*.* /E /Y
SQL Server has to use a domain account to run under, otherwise it does not
have a way to authenticate itself with the other server.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Menzin" <LarryMenzin@.discussions.microsoft.com> wrote in message
news:B52A63D9-A817-430C-9B0F-17139F121FBC@.microsoft.com...
> My client has about 3 servers with several databases on each. These
> databases
> are backed up to disk using maintenance plans. This client wants to copy
> SQL
> backup files on the disks of these servers to an additional server with a
> tape drive to do consolidated backup to tape.
> Is the best way to copy backup files already on disk to a network share to
> use a DOS copy command through SQL Agent?
> If so, is it best to run SQL Agent using a domain account with substantial
> rights to ensure that SQL agent has appropriate file permissions both
> locally
> and on network paths? When SQL agent runs under the local system account,
> file copy operations fail with "Access denied" messages.
> Does anyone have suggestions on how to do this task?
> --
> Larry Menzin
> American Techsystems Corp.