At 09:55 AM 11/9/2001 -0500, David Ehresman wrote: >We run our recovery log in Roll forward mode. We recently added some >recovery log space and now would like to remove some of the old recovery >log space. We apparently have to change our recovery log to Normal mode >to do this. > >What are the operational implications of moving from Roll forward to >Normal and from Normal to Roll forward? Does either force a data base backup?
Switching from Rollforward to Normal does not force a database backup. Switching from Normal to Rollforward DOES force a database backup. -- Paul Zarnowski Ph: 607-255-4757 747 Rhodes Hall, Cornell University Fx: 607-255-8521 Ithaca, NY 14853-3801 Em: [EMAIL PROTECTED]
