Hi,
Thanks Del

For the DSM.OPT file for SQL, this is my configuration ... do I need more
config

NODename          xxxxxxxx
CLUSTERnode       no
COMPRESSIon       Off
PASSWORDAccess    Generate

COMMMethod        TCPip
TCPPort           1500
TCPServeraddress  {IP TSM SERVER)
TCPWindowsize     63
TCPBuffSize       32
SCHEDLOGRetention     10
SCHEDMODE             Prompted
TCPCLIENTPORT         1502

thanks

Luc




Del Hoobler <hoobler AT US.IBM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-08-19 05:35 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Restoring SQL Database Question


Luc,

Is a full backup "enough" for what?

A Data Protection for SQL "FULL" backup can be used to
restore a complete database. When a full backup is
taken it also captures pieces of the log that it needs
to fully recover the database. You do not need a
separate "LOG" backup in order to perform a database recovery.
I hope that answers your question.

When you say "settings to look at in the DSM.OPT"...
what do you mean? To perform a FULL backup?

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/19/2004
03:35:02 PM:

> Hi again
>
> Is a full backup enought or I should take a backup of the log too ??
> Is there any settings to look at in the DSM.OPT for SQL ??
>