>>>>> 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users