Backup error

Hello
I was told by email someone got an backup error and I gotta reply something
to him, what reasons can there be for this error? All services are running
and disk isnt full
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'Backup All Databases'' (0xE09A5EC5A9A4CE4C859FA208632D02D8) - Status:
Failed - Invoked on: 2006-02-17 00:00:00 - Message: The job failed. The Job
was invoked by Schedule 2 (Schedule 1). The last step to run was step 1
(Step 1).There has to be a more detailed error description, this one is telling
you nothing, Look at the particular step of this Maintanance job. As
the maintainance wiurad is creating jobs for all the work which is done
with him, there should be more error descriptions. See if the jobs have
a log purged out, can be found on one tab of the Job step.
HTH, Jens Suessmeyer.|||Jens,
I dont see a step in there, it all looks fine under Database Maintanence
Plans, it's a job that backs up all databases... not sure where to look
<Jens.Suessmeyer@.googlemail.com> wrote in message
news:1140164119.642261.146590@.z14g2000cwz.googlegroups.com...
> There has to be a more detailed error description, this one is telling
> you nothing, Look at the particular step of this Maintanance job. As
> the maintainance wiurad is creating jobs for all the work which is done
> with him, there should be more error descriptions. See if the jobs have
> a log purged out, can be found on one tab of the Job step.
> HTH, Jens Suessmeyer.
>|||Configure the maint plan to create a report file and check that report file
for the actual error
message.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Lasse Edsvik" <lasse@.nospam.com> wrote in message news:OFWw7%235MGHA.2580@.TK2MSFTNGP14.phx
.gbl...
> Jens,
> I dont see a step in there, it all looks fine under Database Maintanence
> Plans, it's a job that backs up all databases... not sure where to look
>
> <Jens.Suessmeyer@.googlemail.com> wrote in message
> news:1140164119.642261.146590@.z14g2000cwz.googlegroups.com...
>

backup and restore Question

I had used to make full backup of a database and using winzip to compress
the file to transfer it via email to another location. And because of the
big email attachement of the compressed database I didn't succeed in
transfering the data. Then I tried to alter the database as adding a
secondary group file with 2 files.
and I tried to backup the files each indivually and on the another location
(SERVER) I tried to restore the files but I didn't succeed.
How Can I achieve this goal without any errors ?How about just backup the db and then handling both files? When you backup
the db, both files are backed up.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Whatever number of files you have, the db backup should back them all up.
Then you can compress them all, mail them all, restore the db with them
all -- treating the group of files the same as if there were only one file.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
> The Goal is to get 3 or more files to compress and send via email not one
> big file
>
> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
> > How about just backup the db and then handling both files? When you
> backup
> > the db, both files are backed up.
> >
> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> > > I had used to make full backup of a database and using winzip to
> compress
> > > the file to transfer it via email to another location. And because of
> the
> > > big email attachement of the compressed database I didn't succeed in
> > > transfering the data. Then I tried to alter the database as adding a
> > > secondary group file with 2 files.
> > > and I tried to backup the files each indivually and on the another
> > location
> > > (SERVER) I tried to restore the files but I didn't succeed.
> > > How Can I achieve this goal without any errors ?
> > >
> > >
> >
> >
>|||I backup DBs on production server, zip them into a RAR file (170 MB) and
schedule a DTS job to FTP the file to an off-site location. How big is your
attachment?
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Doesn't winzip give an option to split the zip file into
multiple files? Don't have it installed here to check.
>--Original Message--
>Whatever number of files you have, the db backup should
back them all up.
>Then you can compress them all, mail them all, restore
the db with them
>all -- treating the group of files the same as if there
were only one file.
>"Awada" <awada@.pharmacare-ltd.com> wrote in message
>news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
>> The Goal is to get 3 or more files to compress and send
via email not one
>> big file
>>
>> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
>> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
>> > How about just backup the db and then handling both
files? When you
>> backup
>> > the db, both files are backed up.
>> >
>> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
>> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
>> > > I had used to make full backup of a database and
using winzip to
>> compress
>> > > the file to transfer it via email to another
location. And because of
>> the
>> > > big email attachement of the compressed database I
didn't succeed in
>> > > transfering the data. Then I tried to alter the
database as adding a
>> > > secondary group file with 2 files.
>> > > and I tried to backup the files each indivually and
on the another
>> > location
>> > > (SERVER) I tried to restore the files but I didn't
succeed.
>> > > How Can I achieve this goal without any errors ?
>> > >
>> > >
>> >
>> >
>>
>
>.
>|||Awada -
I follow this process -
1. Backup the Database
2. Rar the DB (Ours is too large for winzip)
3. FTP the database to the remote server
4. Unrar and restore on remote server
This whole process can be automated in a couple of different ways if
you want to (I did).
HTH
"Awada" <awada@.pharmacare-ltd.com> wrote in message news:<OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl>...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?

Backup and restore - What is the preffered way?

What is the preferred way for Backup and Restore? Maintenance plan wizard
or command line scripts?
Also, to setup email notifications on a sql box, what do we need (outlook
client..) on the server box? Is there a step by step document online to
setup this?
Plus please post some links to backup command scripts pages.
Thanks
BVR"Uhway" <vbhadharla@.sbcglobal.net> wrote in message
news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
> What is the preferred way for Backup and Restore? Maintenance plan wizard
> or command line scripts?
T-SQL scheduled using SQL Server Agent Service
> Also, to setup email notifications on a sql box, what do we need (outlook
> client..) on the server box? Is there a step by step document online to
> setup this?
You need outlook 2000 onwards installed on the box SQL is installed. SQL
Server is going to be a member of a domain and a MAPI mail server has be to
used (e.g Exchange)
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/default.mspx
> Plus please post some links to backup command scripts pages.
The BOOKS Online (get the updated version from www.microsoft.com/sql) is
more then enough as a resource for writing T-SQL for Backup/Restore
> Thanks
> BVR
>
Cheers
Gill|||http://weblogs.sqlteam.com/tarad
Tara has some good backup/restore scripts. She has a standard version and a
SQL LiteSpeed version.
"Uhway" <vbhadharla@.sbcglobal.net> wrote in message
news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
> What is the preferred way for Backup and Restore? Maintenance plan wizard
> or command line scripts?
> Also, to setup email notifications on a sql box, what do we need (outlook
> client..) on the server box? Is there a step by step document online to
> setup this?
> Plus please post some links to backup command scripts pages.
> Thanks
> BVR
>|||"Sarbjit Gill" <ssgill.no.spam@.no.spam.hotmail.com> wrote in message
news:%23hl3NHa9EHA.1408@.TK2MSFTNGP10.phx.gbl...
> "Uhway" <vbhadharla@.sbcglobal.net> wrote in message
> news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
> > What is the preferred way for Backup and Restore? Maintenance plan
wizard
> > or command line scripts?
> T-SQL scheduled using SQL Server Agent Service
> >
> > Also, to setup email notifications on a sql box, what do we need
(outlook
> > client..) on the server box? Is there a step by step document online to
> > setup this?
> You need outlook 2000 onwards installed on the box SQL is installed. SQL
> Server is going to be a member of a domain and a MAPI mail server has be
to
> used (e.g Exchange)
>
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/default.mspx
This is not true. Yes, you need a MAPI client, but you can seti it up to
use an SMTP server. In fact that's what I find to be the most stable, set
up an SMTP server on the same box as the SQL Server and use that to forward
outgoing email. This eliminates the problem of the mail client locking up
due to time outs.
> >
> > Plus please post some links to backup command scripts pages.
> The BOOKS Online (get the updated version from www.microsoft.com/sql) is
> more then enough as a resource for writing T-SQL for Backup/Restore
> >
> > Thanks
> > BVR
> >
> >
> Cheers
> Gill
>
>|||Thanks
BVR
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:OCYipwc9EHA.2788@.TK2MSFTNGP15.phx.gbl...
> http://weblogs.sqlteam.com/tarad
> Tara has some good backup/restore scripts. She has a standard version and
a
> SQL LiteSpeed version.
>
> "Uhway" <vbhadharla@.sbcglobal.net> wrote in message
> news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
> > What is the preferred way for Backup and Restore? Maintenance plan
wizard
> > or command line scripts?
> >
> > Also, to setup email notifications on a sql box, what do we need
(outlook
> > client..) on the server box? Is there a step by step document online to
> > setup this?
> >
> > Plus please post some links to backup command scripts pages.
> >
> > Thanks
> > BVR
> >
> >
>

Backup and restore - What is the preffered way?

What is the preferred way for Backup and Restore? Maintenance plan wizard
or command line scripts?
Also, to setup email notifications on a sql box, what do we need (outlook
client..) on the server box? Is there a step by step document online to
setup this?
Plus please post some links to backup command scripts pages.
Thanks
BVR"Uhway" <vbhadharla@.sbcglobal.net> wrote in message
news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
> What is the preferred way for Backup and Restore? Maintenance plan wizard
> or command line scripts?
T-SQL scheduled using SQL Server Agent Service
> Also, to setup email notifications on a sql box, what do we need (outlook
> client..) on the server box? Is there a step by step document online to
> setup this?
You need outlook 2000 onwards installed on the box SQL is installed. SQL
Server is going to be a member of a domain and a MAPI mail server has be to
used (e.g Exchange)
http://www.microsoft.com/resources/...us/default.mspx[vbco
l=seagreen]
> Plus please post some links to backup command scripts pages.[/vbcol]
The BOOKS Online (get the updated version from www.microsoft.com/sql) is
more then enough as a resource for writing T-SQL for Backup/Restore
> Thanks
> BVR
>
Cheers
Gill|||http://weblogs.sqlteam.com/tarad
Tara has some good backup/restore scripts. She has a standard version and a
SQL LiteSpeed version.
"Uhway" <vbhadharla@.sbcglobal.net> wrote in message
news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
> What is the preferred way for Backup and Restore? Maintenance plan wizard
> or command line scripts?
> Also, to setup email notifications on a sql box, what do we need (outlook
> client..) on the server box? Is there a step by step document online to
> setup this?
> Plus please post some links to backup command scripts pages.
> Thanks
> BVR
>|||"Sarbjit Gill" <ssgill.no.spam@.no.spam.hotmail.com> wrote in message
news:%23hl3NHa9EHA.1408@.TK2MSFTNGP10.phx.gbl...
> "Uhway" <vbhadharla@.sbcglobal.net> wrote in message
> news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
wizard[vbcol=seagreen]
> T-SQL scheduled using SQL Server Agent Service
(outlook[vbcol=seagreen]
> You need outlook 2000 onwards installed on the box SQL is installed. SQL
> Server is going to be a member of a domain and a MAPI mail server has be
to
> used (e.g Exchange)
>
http://www.microsoft.com/resources/...lt
.mspx
This is not true. Yes, you need a MAPI client, but you can seti it up to
use an SMTP server. In fact that's what I find to be the most stable, set
up an SMTP server on the same box as the SQL Server and use that to forward
outgoing email. This eliminates the problem of the mail client locking up
due to time outs.

> The BOOKS Online (get the updated version from www.microsoft.com/sql) is
> more then enough as a resource for writing T-SQL for Backup/Restore
> Cheers
> Gill
>
>|||Thanks
BVR
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:OCYipwc9EHA.2788@.TK2MSFTNGP15.phx.gbl...
> http://weblogs.sqlteam.com/tarad
> Tara has some good backup/restore scripts. She has a standard version and
a
> SQL LiteSpeed version.
>
> "Uhway" <vbhadharla@.sbcglobal.net> wrote in message
> news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
wizard[vbcol=seagreen]
(outlook[vbcol=seagreen]
>

Backup and restore - What is the preffered way?

What is the preferred way for Backup and Restore? Maintenance plan wizard
or command line scripts?
Also, to setup email notifications on a sql box, what do we need (outlook
client..) on the server box? Is there a step by step document online to
setup this?
Plus please post some links to backup command scripts pages.
Thanks
BVR
"Uhway" <vbhadharla@.sbcglobal.net> wrote in message
news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
> What is the preferred way for Backup and Restore? Maintenance plan wizard
> or command line scripts?
T-SQL scheduled using SQL Server Agent Service
> Also, to setup email notifications on a sql box, what do we need (outlook
> client..) on the server box? Is there a step by step document online to
> setup this?
You need outlook 2000 onwards installed on the box SQL is installed. SQL
Server is going to be a member of a domain and a MAPI mail server has be to
used (e.g Exchange)
http://www.microsoft.com/resources/d...s/default.mspx
> Plus please post some links to backup command scripts pages.
The BOOKS Online (get the updated version from www.microsoft.com/sql) is
more then enough as a resource for writing T-SQL for Backup/Restore
> Thanks
> BVR
>
Cheers
Gill
|||http://weblogs.sqlteam.com/tarad
Tara has some good backup/restore scripts. She has a standard version and a
SQL LiteSpeed version.
"Uhway" <vbhadharla@.sbcglobal.net> wrote in message
news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
> What is the preferred way for Backup and Restore? Maintenance plan wizard
> or command line scripts?
> Also, to setup email notifications on a sql box, what do we need (outlook
> client..) on the server box? Is there a step by step document online to
> setup this?
> Plus please post some links to backup command scripts pages.
> Thanks
> BVR
>
|||"Sarbjit Gill" <ssgill.no.spam@.no.spam.hotmail.com> wrote in message
news:%23hl3NHa9EHA.1408@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> "Uhway" <vbhadharla@.sbcglobal.net> wrote in message
> news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
wizard[vbcol=seagreen]
> T-SQL scheduled using SQL Server Agent Service
(outlook
> You need outlook 2000 onwards installed on the box SQL is installed. SQL
> Server is going to be a member of a domain and a MAPI mail server has be
to
> used (e.g Exchange)
>
http://www.microsoft.com/resources/d...s/default.mspx
This is not true. Yes, you need a MAPI client, but you can seti it up to
use an SMTP server. In fact that's what I find to be the most stable, set
up an SMTP server on the same box as the SQL Server and use that to forward
outgoing email. This eliminates the problem of the mail client locking up
due to time outs.

> The BOOKS Online (get the updated version from www.microsoft.com/sql) is
> more then enough as a resource for writing T-SQL for Backup/Restore
> Cheers
> Gill
>
>
|||Thanks
BVR
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:OCYipwc9EHA.2788@.TK2MSFTNGP15.phx.gbl...
> http://weblogs.sqlteam.com/tarad
> Tara has some good backup/restore scripts. She has a standard version and
a[vbcol=seagreen]
> SQL LiteSpeed version.
>
> "Uhway" <vbhadharla@.sbcglobal.net> wrote in message
> news:ev0apRU9EHA.2804@.TK2MSFTNGP15.phx.gbl...
wizard[vbcol=seagreen]
(outlook
>

Backup and notify operator

We are using SQL Server 2005.
We do transaction backup every 15 minutes and we notify the operator by
email every time after the backup. So, there is a lot of emails the whole
day.
I am wondering if there is a way to only notify the operator only when there
is a problem with the backup.
Thank you.On Job Pproperties, Notifications, E-mail there are three choices. Perhaps
you are using 'When the job completes'. Select 'When the job fails' instead.
Hope this helps,
Ben Nevarez
"fniles" wrote:
> We are using SQL Server 2005.
> We do transaction backup every 15 minutes and we notify the operator by
> email every time after the backup. So, there is a lot of emails the whole
> day.
> I am wondering if there is a way to only notify the operator only when there
> is a problem with the backup.
> Thank you.
>
>|||Thank you.
When I right click - Edit on the Notify Operator Task, I only see "operators
to notify" and "notification message to send:"
I do not see the 3 choices. Is this because I am using SQL Server 2005
Developer version ?
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
> On Job Pproperties, Notifications, E-mail there are three choices. Perhaps
> you are using 'When the job completes'. Select 'When the job fails'
> instead.
> Hope this helps,
> Ben Nevarez
>
>
> "fniles" wrote:
>> We are using SQL Server 2005.
>> We do transaction backup every 15 minutes and we notify the operator by
>> email every time after the backup. So, there is a lot of emails the whole
>> day.
>> I am wondering if there is a way to only notify the operator only when
>> there
>> is a problem with the backup.
>> Thank you.
>>|||Developer Edition is fine. Go to Jobs, double-click your job, Notifications,
E-mail must be checked, on the right there is a list. Select the list.
Perhaps you are using 'When the job completes'. Select 'When the job fails'
instead.
Hope this helps,
Ben Nevarez
"fniles" wrote:
> Thank you.
> When I right click - Edit on the Notify Operator Task, I only see "operators
> to notify" and "notification message to send:"
> I do not see the 3 choices. Is this because I am using SQL Server 2005
> Developer version ?
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
> >
> > On Job Pproperties, Notifications, E-mail there are three choices. Perhaps
> > you are using 'When the job completes'. Select 'When the job fails'
> > instead.
> >
> > Hope this helps,
> >
> > Ben Nevarez
> >
> >
> >
> >
> > "fniles" wrote:
> >
> >> We are using SQL Server 2005.
> >> We do transaction backup every 15 minutes and we notify the operator by
> >> email every time after the backup. So, there is a lot of emails the whole
> >> day.
> >> I am wondering if there is a way to only notify the operator only when
> >> there
> >> is a problem with the backup.
> >> Thank you.
> >>
> >>
> >>
>
>|||It looks like you were referring to SQL 2000. I do see what you are
referring to in SQL 2000. I am using SQL 2005. I do not see "Jobs" in SQL
2005.
Do you know how I can do this in SQL 2005 ?
Thank you.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:BC2F9E23-D44D-40C3-BB49-55910DA35015@.microsoft.com...
> Developer Edition is fine. Go to Jobs, double-click your job,
> Notifications,
> E-mail must be checked, on the right there is a list. Select the list.
> Perhaps you are using 'When the job completes'. Select 'When the job
> fails'
> instead.
> Hope this helps,
> Ben Nevarez
>
>
> "fniles" wrote:
>> Thank you.
>> When I right click - Edit on the Notify Operator Task, I only see
>> "operators
>> to notify" and "notification message to send:"
>> I do not see the 3 choices. Is this because I am using SQL Server 2005
>> Developer version ?
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
>> >
>> > On Job Pproperties, Notifications, E-mail there are three choices.
>> > Perhaps
>> > you are using 'When the job completes'. Select 'When the job fails'
>> > instead.
>> >
>> > Hope this helps,
>> >
>> > Ben Nevarez
>> >
>> >
>> >
>> >
>> > "fniles" wrote:
>> >
>> >> We are using SQL Server 2005.
>> >> We do transaction backup every 15 minutes and we notify the operator
>> >> by
>> >> email every time after the backup. So, there is a lot of emails the
>> >> whole
>> >> day.
>> >> I am wondering if there is a way to only notify the operator only when
>> >> there
>> >> is a problem with the backup.
>> >> Thank you.
>> >>
>> >>
>> >>
>>|||If I am understanding correctly what you have done, you have created a
maintenance plan in SQL 2005. In that maintenance plan (actually that
sub-plan), you have two tasks. The backup task and a notify operator
task, connected by a precedence constraint (green line with an arrow
pointing to the notify operator task).
If so, just right click on the precedence constraint and change it from
success to failure. Then, the notify operator task will only run when
the preceding task fails.
HTH,
Jeff
fniles wrote:
> It looks like you were referring to SQL 2000. I do see what you are
> referring to in SQL 2000. I am using SQL 2005. I do not see "Jobs" in SQL
> 2005.
> Do you know how I can do this in SQL 2005 ?
> Thank you.
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:BC2F9E23-D44D-40C3-BB49-55910DA35015@.microsoft.com...
>> Developer Edition is fine. Go to Jobs, double-click your job,
>> Notifications,
>> E-mail must be checked, on the right there is a list. Select the list.
>> Perhaps you are using 'When the job completes'. Select 'When the job
>> fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> Thank you.
>> When I right click - Edit on the Notify Operator Task, I only see
>> "operators
>> to notify" and "notification message to send:"
>> I do not see the 3 choices. Is this because I am using SQL Server 2005
>> Developer version ?
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
>> On Job Pproperties, Notifications, E-mail there are three choices.
>> Perhaps
>> you are using 'When the job completes'. Select 'When the job fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> We are using SQL Server 2005.
>> We do transaction backup every 15 minutes and we notify the operator
>> by
>> email every time after the backup. So, there is a lot of emails the
>> whole
>> day.
>> I am wondering if there is a way to only notify the operator only when
>> there
>> is a problem with the backup.
>> Thank you.
>>
>>
>>
>
>|||Thank you.
If I change it to failure, if the process only fail partially, will it
report it to the operator ?
"Jeffrey Williams" <jeff.williams3188@.verizon.net> wrote in message
news:e7uo%23IXVIHA.2368@.TK2MSFTNGP05.phx.gbl...
> If I am understanding correctly what you have done, you have created a
> maintenance plan in SQL 2005. In that maintenance plan (actually that
> sub-plan), you have two tasks. The backup task and a notify operator
> task, connected by a precedence constraint (green line with an arrow
> pointing to the notify operator task).
> If so, just right click on the precedence constraint and change it from
> success to failure. Then, the notify operator task will only run when the
> preceding task fails.
> HTH,
> Jeff
> fniles wrote:
>> It looks like you were referring to SQL 2000. I do see what you are
>> referring to in SQL 2000. I am using SQL 2005. I do not see "Jobs" in SQL
>> 2005.
>> Do you know how I can do this in SQL 2005 ?
>> Thank you.
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:BC2F9E23-D44D-40C3-BB49-55910DA35015@.microsoft.com...
>> Developer Edition is fine. Go to Jobs, double-click your job,
>> Notifications,
>> E-mail must be checked, on the right there is a list. Select the list.
>> Perhaps you are using 'When the job completes'. Select 'When the job
>> fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> Thank you.
>> When I right click - Edit on the Notify Operator Task, I only see
>> "operators
>> to notify" and "notification message to send:"
>> I do not see the 3 choices. Is this because I am using SQL Server 2005
>> Developer version ?
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
>> On Job Pproperties, Notifications, E-mail there are three choices.
>> Perhaps
>> you are using 'When the job completes'. Select 'When the job fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> We are using SQL Server 2005.
>> We do transaction backup every 15 minutes and we notify the operator
>> by
>> email every time after the backup. So, there is a lot of emails the
>> whole
>> day.
>> I am wondering if there is a way to only notify the operator only
>> when
>> there
>> is a problem with the backup.
>> Thank you.
>>
>>
>>
>>|||What do you mean by fail partially? Either the task completes
successfully, or the task fails - there is no partial failure.
But, if you have multiple tasks in the sub-plan and a single notify
operator task - with all tasks connected to the notify operator task on
failure the notify operator task will only fire if all tasks fail. To
get the notify operator task to fire if any one task fails you need to
right-click on one of the failure (red arrow) constraints and change
from AND to OR condition.
Or, you can add a separate notify operator task for each individual task
in the sub-plan. For example, you would have a Check Database Integrity
Task, Rebuild Index Task, Update Statistics, Backup Task and Cleanup
Task (connected in order on success) with a notify operator task
connected to the Database Integrity Task, a separate notify operator
task connected to the Rebuild Index Task, etc...
fniles wrote:
> Thank you.
> If I change it to failure, if the process only fail partially, will it
> report it to the operator ?
> "Jeffrey Williams" <jeff.williams3188@.verizon.net> wrote in message
> news:e7uo%23IXVIHA.2368@.TK2MSFTNGP05.phx.gbl...
>> If I am understanding correctly what you have done, you have created a
>> maintenance plan in SQL 2005. In that maintenance plan (actually that
>> sub-plan), you have two tasks. The backup task and a notify operator
>> task, connected by a precedence constraint (green line with an arrow
>> pointing to the notify operator task).
>> If so, just right click on the precedence constraint and change it from
>> success to failure. Then, the notify operator task will only run when the
>> preceding task fails.
>> HTH,
>> Jeff
>> fniles wrote:
>> It looks like you were referring to SQL 2000. I do see what you are
>> referring to in SQL 2000. I am using SQL 2005. I do not see "Jobs" in SQL
>> 2005.
>> Do you know how I can do this in SQL 2005 ?
>> Thank you.
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:BC2F9E23-D44D-40C3-BB49-55910DA35015@.microsoft.com...
>>
>> Developer Edition is fine. Go to Jobs, double-click your job,
>> Notifications,
>> E-mail must be checked, on the right there is a list. Select the list.
>> Perhaps you are using 'When the job completes'. Select 'When the job
>> fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> Thank you.
>> When I right click - Edit on the Notify Operator Task, I only see
>> "operators
>> to notify" and "notification message to send:"
>> I do not see the 3 choices. Is this because I am using SQL Server 2005
>> Developer version ?
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
>>
>> On Job Pproperties, Notifications, E-mail there are three choices.
>> Perhaps
>> you are using 'When the job completes'. Select 'When the job fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>>> We are using SQL Server 2005.
>>> We do transaction backup every 15 minutes and we notify the operator
>>> by
>>> email every time after the backup. So, there is a lot of emails the
>>> whole
>>> day.
>>> I am wondering if there is a way to only notify the operator only
>>> when
>>> there
>>> is a problem with the backup.
>>> Thank you.
>>>
>>>
>>>
>>>
>>>
>>
>
>