Re: SQL Agent

[William Degli-Angeli]

>From Microsoft's "Transaction-SQL Help" for BACKUP DATABASE for SQL 2000:

    "Note  During a full database or differential backup, Microsoft® SQL
Server?
               backs up enough of the transaction log to produce a
consistent database
               for when the database is restored"

>From Microsoft's "Transaction-SQL Help" for BACKUP LOG for SQL 2000:

    "Specifies a backup of the transaction log only. The log is backed up
from the last
      successfully executed LOG backup to the current end of the log. Once
the log is
      backed up, the space may be truncated when no longer required by
replication or
      active transactions."





                                                                                       
                   
                    Mark D Baker                                                       
                   
                    <mbake5@JCPENN       To:     [EMAIL PROTECTED]                  
                   
                    EY.COM>              cc:                                           
                   
                    Sent by:             Subject:     SQL Agent                        
                   
                    "ADSM: Dist                                                        
                   
                    Stor Manager"                                                      
                   
                    <[EMAIL PROTECTED]                                                     
                   
                    IST.EDU>                                                           
                   
                                                                                       
                   
                                                                                       
                   
                    04/19/2001                                                         
                   
                    15:06                                                              
                   
                    Please respond                                                     
                   
                    to "ADSM: Dist                                                     
                   
                    Stor Manager"                                                      
                   
                                                                                       
                   
                                                                                       
                   



I noticed that the complete database backup does not truncate the log
afterwards.  Will the first transaction log backup after the
complete database backup contain transactions from both before and after
the complete database backup?  If so, will applying the transaction log
backup to the restored database duplicate the transactions created
before the complete database backup?  Thanks.