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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-08-19 05:35 PM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 ?? >