If you do a full backup and truncate the logs and you can only restore from the most recent backup and then rolling forward the subsequent logs. If you do a full backup but do not truncate the logs, I do not think you will be able to roll the logs forward on a restore, but I have never tried. I would suggest testing this if it is part of the decision process.
Justin p.s. I have never heard of the latter being possible. Have you actually done this with informix> > -----Original Message----- > From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 04, 2002 2:27 PM > To: CF-Talk > Subject: OT: SQL Backup/Restore Question > > Recently someone told me something about MS SQL > backup/restore that I would > like to verify. I haven't been able to find anything in any > books or on the > MS site to clarify. So I thought I'd ask here for either a > direct answer or > a place to go search. > > The Scenario: > > Backups are done every night at midnight. In between, backups of the > transaction logs are done every two hours. > > The question: > > It's Thursday. I need to restore my database, but the most > recent backup > (e.g., Wed night) is corrupt. Can I go back to the previous > backup (e.g. > Tue night) and apply all of the transaction logs through > Thursday? Or would > I only be able to apply them up until the Wednesday night backup? > > I've been told that MS SQL won't let me apply transaction > logs for (in this > example) Thursday unless I started with the Wednesday night > backup. I know > Informix would allow me to apply all of the logs. We're > about to switch to > MS SQL and I want to be sure we set up the appropriate backup > procedures. > > Any thoughts on how I could get to the bottom of this would > be appreciated. > > Athelene Gieseman > [EMAIL PROTECTED] > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
