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
Paul Zarnowski                         Ph: 607-255-4757
747 Rhodes Hall, Cornell University    Fx: 607-255-8521
Ithaca, NY 14853-3801                  Em: psz1 AT cornell DOT edu