Re: [ADSM-L] TDP SQL Backups
2007-04-25 13:09:50
What I was trying to use was a windows AD account. I wanted to use this
because this going to become a standard in my organization.
Thanks,
---------------------------------------------------------------
Bruce Kamp
Senior Server Analyst
Memorial Healthcare System
E-Mail: bkamp AT mhs DOT net
Phone: (954) 276-4097
Fax: (954) 276-5381
---------------------------------------------------------------
-----Original Message-----
From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM]
Sent: Wednesday, April 25, 2007 12:37 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TDP SQL Backups
Bruce,
If you want to use SQL Server authentication. i.e.
/SQLAUTHentication=SQLuserid
Did you try to use the GUI---> Utilities ---> SQL Server Login Settings
to set your SQL Server login id and password?
Then, stop the DP/SQL GUI... and try this command:
TDPSQLC QUERY SQL /SQLAUTHentication=SQLuserid /sqluser=user
and then
TDPSQLC BACKUP dbname FULL /SQLAUTHentication=SQLuserid /sqluser=user
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 04/25/2007
10:04:48 AM:
> 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?
|
|
|