Mark Breen
marklbreen at gmail.com
Wed Feb 29 14:35:48 CST 2012
Hello John, I am interested to see how you get on with this. But with full and diff, do you really need to back up the log also? Would it not be sufficient to back up the main db on Sunday and diffs each half hour? Is that the wrong way to do it? IF the diffs were small, would it be good enough? I have never experimented with restoring log files so I am eager to see how you get on. Mark On 29 February 2012 19:17, jwcolby <jwcolby at colbyconsulting.com> wrote: > Does anyone know of a utility to track backups of a database from the > full, each differential and the log file backups and allow you to just > point to one of the above backups and restore each piece in order? IOW if > I do a full backup Sunday night, a differential every weekday night, and > log backups every 1/2 hour, I would like to point to the a log file backup > somehow (in a table?) and have the software understand that the backup > chain for that log backup starts at the Sunday night full and progresses > through each intermediary backup? So I could click a button and restore > down through the backup chain. > > Does such a thing exist? Is such a thing even possible? > > For the moment I am using the scripts from here: > > http://ola.hallengren.com/sql-**server-backup.html<http://ola.hallengren.com/sql-server-backup.html> > > They appear to perform exactly as claimed. I am able to get Full, DIFF > and LOG backups easily and quickly. What I am missing is the ability to > restore these things easily and quickly. Restoring a full is easy, after > that not so easy. > > -- > John W. Colby > Colby Consulting > > Reality is what refuses to go away > when you do not believe in it > > > ______________________________**_________________ > dba-SQLServer mailing list > dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> > http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> > http://www.databaseadvisors.**com <http://www.databaseadvisors.com> > >