Re: [ADSM-L] TDP SQL Backups
2007-04-25 12:37:57
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?
|
|
|