>>>>> On Thu, 13 Aug 2009 10:05:14 +1000, James Harper said: > > I do a full backup once a week, and then incremental backups for the > rest of the week. > > MSSQL is configured to back up transaction logs every day and keep the > backup for 3 days (by which time it would have been backed up). It's > Thursday today and I want to restore the most recent full backup > (Saturday night) and all the subsequent transaction logs, but of course > because accurate backup is on I'm going to have to do multiple restores > at various points - restore as at Monday night to get Saturday + Sunday > logfiles, then restore at Wednesday night to get Monday + Tuesday > logfiles, etc. Restoring as at last nights backup will only give me the > logfiles that existed at the time.
So why are you using accurate backups for this case? __Martin ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
