Emailing SQL 2000 maintenance report via SMTP?

Hi All
As per my post in microsoft... server NG, I keep getting a problem where my
DB maintenance plan just stops doing what it should, which in turn means
that if I don't paranoid-ly check it each day I get the scenario (like
today) where I find my backups haven't been working for a month!!!
What I would like to do is email the maintenance plan to a designated email
address so that I can easily see every morning whether or not it has worked.
I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
Exchange Server and I don't use this. I don't even have it running on my
SBS 2000 Server.
Is there anyway in SQL 2000 that I can get it to email the report via SMTP?
I'm familiar with JMail and it's COM/DLL is installed on my server if I
could use that.
Thanks RobbieFirst of all, can I suggest that you not use the maintenance plan for
backups? You can create jobs within the SQL Server Agent that will backup
your databases. Books Online (within the SQL Server program group) contains
T-SQL examples of backup scripts. If you are so inclined you can also
create jobs that perform the appropriate maintenance tasks (such as checkdb,
checkcatalog, updateusage, update statistics).
You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts.
Keith
"Astra" <info@.noemail.com> wrote in message
news:uXPyFCzGFHA.2452@.TK2MSFTNGP10.phx.gbl...
> Hi All
> As per my post in microsoft... server NG, I keep getting a problem where
my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
> What I would like to do is email the maintenance plan to a designated
email
> address so that I can easily see every morning whether or not it has
worked.
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange server and I don't use this. I don't even have it running on my
> SBS 2000 Server.
> Is there anyway in SQL 2000 that I can get it to email the report via
SMTP?
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
> Thanks Robbie
>|||Hi
Check out http://www.sqldev.net/xp/xpsmtp.htm
Other possible mechanisms might mbe Notification Services or Reporting
Services.
John
"Astra" wrote:

> Hi All
> As per my post in microsoft... server NG, I keep getting a problem where
my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
> What I would like to do is email the maintenance plan to a designated emai
l
> address so that I can easily see every morning whether or not it has worke
d.
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange server and I don't use this. I don't even have it running on my
> SBS 2000 Server.
> Is there anyway in SQL 2000 that I can get it to email the report via SMTP
?
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
> Thanks Robbie
>
>|||Check out http://www.sqldev.net/xp.htm
HTH...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
Keith Kratochvil wrote:
> First of all, can I suggest that you not use the maintenance plan for
> backups? You can create jobs within the SQL Server Agent that will backup
> your databases. Books Online (within the SQL Server program group) contai
ns
> T-SQL examples of backup scripts. If you are so inclined you can also
> create jobs that perform the appropriate maintenance tasks (such as checkd
b,
> checkcatalog, updateusage, update statistics).
> You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts.
>|||Thanks Guys
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:2E065D49-E910-48D1-8B7D-1B4FFB55DA73@.microsoft.com...
Hi
Check out http://www.sqldev.net/xp/xpsmtp.htm
Other possible mechanisms might mbe Notification Services or Reporting
Services.
John
"Astra" wrote:

> Hi All
> As per my post in microsoft... server NG, I keep getting a problem where
> my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
> What I would like to do is email the maintenance plan to a designated
> email
> address so that I can easily see every morning whether or not it has
> worked.
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange server and I don't use this. I don't even have it running on my
> SBS 2000 Server.
> Is there anyway in SQL 2000 that I can get it to email the report via
> SMTP?
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
> Thanks Robbie
>
>|||Keith,
I have found this useful as well, so thanks for the tip.
I am having difficulty putting in carriage returns and linefeeds and
wondered if you could help.
This works (names changed!):
exec master.dbo.xp_smtp_sendmail
@.FROM = 'Fred@.mail.com',
@.TO = 'Jim@.mail.com',
@.subject = 'Hello SQL Server SMTP Mail',
@.message = 'Goodbye MAPI and Outlook
@.server = 'ServerIPAddress'
But when I try and add a carriage return and line feed I get 'Incorrect
syntax near '+'' error:
exec master.dbo.xp_smtp_sendmail
@.FROM = 'Fred@.mail.com',
@.TO = 'Jim@.mail.com',
@.subject = 'Hello SQL Server SMTP Mail',
@.message = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10),
@.server = 'ServerIPAddress'
I would welcome some help.
Thanks,
Adrian
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:Oia5I9zGFHA.1172@.TK2MSFTNGP12.phx.gbl...
> First of all, can I suggest that you not use the maintenance plan for
> backups? You can create jobs within the SQL Server Agent that will backup
> your databases. Books Online (within the SQL Server program group)
contains
> T-SQL examples of backup scripts. If you are so inclined you can also
> create jobs that perform the appropriate maintenance tasks (such as
checkdb,
> checkcatalog, updateusage, update statistics).
> You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts.
> --
> Keith
>
> "Astra" <info@.noemail.com> wrote in message
> news:uXPyFCzGFHA.2452@.TK2MSFTNGP10.phx.gbl...
where
> my
> email
> worked.
MS
my
> SMTP?
>|||On Fri, 25 Feb 2005 16:33:12 -0000, Adrian wrote:
(snip)
>But when I try and add a carriage return and line feed I get 'Incorrect
>syntax near '+'' error:
>exec master.dbo.xp_smtp_sendmail
> @.FROM = 'Fred@.mail.com',
> @.TO = 'Jim@.mail.com',
> @.subject = 'Hello SQL Server SMTP Mail',
> @.message = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10),
> @.server = 'ServerIPAddress'
>I would welcome some help.
Hi Adrian,
Try this:
DECLARE @.msg varchar(40)
SET @.msg = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10)
exec master.dbo.xp_smtp_sendmail
@.FROM = 'Fred@.mail.com',
@.TO = 'Jim@.mail.com',
@.subject = 'Hello SQL Server SMTP Mail',
@.message = @.msg,
@.server = 'ServerIPAddress'
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||CHAR(13) + CHAR(10)
should do it
...
select 'test' + CHAR(13) + CHAR(10) + 'ing'
Keith
"Adrian" <NoSpam@.hotmail.com> wrote in message
news:uMM70e1GFHA.588@.TK2MSFTNGP10.phx.gbl...
> Keith,
> I have found this useful as well, so thanks for the tip.
> I am having difficulty putting in carriage returns and linefeeds and
> wondered if you could help.
> This works (names changed!):
> exec master.dbo.xp_smtp_sendmail
> @.FROM = 'Fred@.mail.com',
> @.TO = 'Jim@.mail.com',
> @.subject = 'Hello SQL Server SMTP Mail',
> @.message = 'Goodbye MAPI and Outlook
> @.server = 'ServerIPAddress'
> But when I try and add a carriage return and line feed I get 'Incorrect
> syntax near '+'' error:
> exec master.dbo.xp_smtp_sendmail
> @.FROM = 'Fred@.mail.com',
> @.TO = 'Jim@.mail.com',
> @.subject = 'Hello SQL Server SMTP Mail',
> @.message = 'Goodbye MAPI and Outlook' + CHAR(13) + CHAR(10),
> @.server = 'ServerIPAddress'
> I would welcome some help.
> Thanks,
> Adrian
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:Oia5I9zGFHA.1172@.TK2MSFTNGP12.phx.gbl...
backup
> contains
> checkdb,
alerts.
> where
means
with
> MS
> my
I
>|||Thanks Keith and Hugo.
It works now.
Adrian
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:u00Ti51GFHA.2936@.TK2MSFTNGP15.phx.gbl...
> CHAR(13) + CHAR(10)
> should do it
> ...
> select 'test' + CHAR(13) + CHAR(10) + 'ing'
> --
> Keith
>
> "Adrian" <NoSpam@.hotmail.com> wrote in message
> news:uMM70e1GFHA.588@.TK2MSFTNGP10.phx.gbl...
> backup
> alerts.
> means
(like
designated
> with
on
via
if
> I
>sql

Emailing from the SQL 2000 server

I have a few maintenance routines created and SQL 2000 has options to email
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/...sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>

Emailing from the SQL 2000 server

I have a few maintenance routines created and SQL 2000 has options to email
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>

Email report to Operator

While configure Email reporting to Operator under Database Maintenance
Plan got below mention error...
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running; check the mail profile and/or the SQLServerAgent service
startup account in the SQLServerAgent properties dialog.
How to overcome this issue?
Please guide!!!!
ThanksDo please check if here is something that can help you:
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/
<darshaksshah@.gmail.com> wrote in message
news:1169890433.901537.64880@.k78g2000cwa.googlegroups.com...
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks
>|||Many Reasons: Out of them
Check to see if your SQL Agent is Running:
Also Check if the DBMail is Started or Setup Properly.
Check SQL Agent is Running under a domain Service Account and if it
has required Priviliges (near to sa) - if the Jobs invlove sending out
Notifications.
I recommend reading BOL more on this.
Maninder
MCDBA
On Jan 27, 4:33 am, darshakss...@.gmail.com wrote:
> While configure Email reporting to Operator under Database Maintenance
> Plan got below mention error...
> Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
> not running; check the mail profile and/or the SQLServerAgent service
> startup account in the SQLServerAgent properties dialog.
> How to overcome this issue?
> Please guide!!!!
> Thanks

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.
You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:

> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>
|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:

> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you nee
d
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
>> Edition Server. We setup some maintenance jobs under Database
>> Maintenance
>> and would like to setup e-mail notification. When we setup
>> notifications,
>> we got the following error message: "Error 22022: SQLServerAgent Error:
>> The SQLServer Agent mail session is not running; check the mail profile
>> and/or the SQLServerAgent service startup account in the SQLServerAgent
>> Properties dialog." What do we need to do? Please let us know if you
>> need
>> additional information. Thank you.
>>

Ejecting Tape automatically after Backup

I had configured a Database Maintenance task for performing daily full
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me'
Thanks
Satyakisatyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out
of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me'
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:

> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/e...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
>
out of[vbcol=seagreen]
Database[vbcol=seagreen]

Ejecting Tape automatically after Backup

I had configured a Database Maintenance task for performing daily full
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me'
Thanks
Satyakisatyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out
of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me'
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:

> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/e...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
>
out of[vbcol=seagreen]
Database[vbcol=seagreen]

Ejecting Tape automatically after Backup

I had configured a Database Maintenance task for performing daily full
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me?
Thanks
Satyaki
satyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me?
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.
|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:

> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>
|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/en...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
out of[vbcol=seagreen]
Database[vbcol=seagreen]

Ejecting Tape automatically after Backup

I had configured a Database Maintenance task for performing daily full
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me'
Thanks
Satyakisatyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me'
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:
> satyaki wrote:
> > I had configured a Database Maintenance task for performing daily full
> > database backup into tape drive and it is working fine.
> >
> > My problem is after performing the backup it is not ejecting the tape out of
> > the drive automatically. Also there is no option available in the Database
> > Maintenace Wizard to configure same.
> >
> > Can any body help me'
> >
> > Thanks
> > Satyaki
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_ba-bz_35ww.asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
> > satyaki wrote:
> > > I had configured a Database Maintenance task for performing daily full
> > > database backup into tape drive and it is working fine.
> > >
> > > My problem is after performing the backup it is not ejecting the tape
out of
> > > the drive automatically. Also there is no option available in the
Database
> > > Maintenace Wizard to configure same.
> > >
> > > Can any body help me'
> > >
> > > Thanks
> > > Satyaki
> >
> > Just a suggestion, we leave the tapes in the drive as it shows that the
> > tape did not run out of space. When a tape is full, it ejects so you
> > can put another in - and the person changing the tapes immediately knows
> > something is wrong.
> >
> >