ADSM-L

Re: [ADSM-L] TDP SQL Backups

2007-04-25 10:10:34
Subject: Re: [ADSM-L] TDP SQL Backups
From: "Bell, Charles (Chip)" <Chip.Bell AT BHSALA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 25 Apr 2007 09:09:38 -0500
It may not be the best way around, but in this situation I have set up a cmd
backup script (fashioned after sqlfull.smp) that ran under SQLServerAgent,
and set it to run under the same account that held sway over SQL Server. My
errors ceased. 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Kamp, Bruce
Sent: Wednesday, April 25, 2007 9:05 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TDP SQL Backups

On some of my SQL servers rights have been taken away from the local system
account to SQL.  In the documentation I found that I can add the username &
password to a user that has rights to backup SQL to the command file to run
the backup.  The problem with this is that it is in clear text so anyone who
has rights to the server can see the username & password.  Is there any
other way to set this up?



Thanks,
---------------------------------------------------------------
Bruce Kamp
Senior Server Analyst
Memorial Healthcare System
E-Mail:  <mailto:bkamp AT mhs DOT net> bkamp AT mhs DOT net
Phone: (954) 276-4097
Fax: (954) 276-5381
---------------------------------------------------------------
-----------------------------------------
Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the
individual or entity named in the address. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this information is strictly
prohibited. If you received this information in error, please
notify the sender and delete this information from your computer
and retain no copies of any of this information.

<Prev in Thread] Current Thread [Next in Thread>