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] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
