Re: Backing Up SE - Questions

>The first chapter states "In general, every transaction log file must >have a corresponding archive copy of the database." I took this to mean that it was necissary to have a transaction log and database backup that are synched (i.e., one logfile=one backup). Not that you must backup the logfile as well. I backup the database and restart the transaction log. I do archive the previous log file just in case the backup is faulty. Then I can restore from the previous backup, and then rollforward using both logs. -- ---------------------------------------------------------------------------- Daniel James - Database Administrator djames@statsci.com Data Analysis Prod Div of MathSoft (formerly StatSci) (206) 283-8802 x284