Hello,
It would be great to have a new parameter that would allow us to change the recovery model to "BULK_LOGGED" before index maintenance and then revert it back to FULL recovery after index maintenance. This would reduce the tlog space used as well as potentially the time it takes for the reindex.
This would obviously be an optional parameter with default of no change in recovery model.
Additionally the documentation would need to provide "caveats" of doing this.
Hello, It would be great to have a new parameter that would allow us to change the recovery model to "BULK_LOGGED" before index maintenance and then revert it back to FULL recovery after index maintenance. This would reduce the tlog space used as well as potentially the time it takes for the reindex.
This would obviously be an optional parameter with default of no change in recovery model.
Additionally the documentation would need to provide "caveats" of doing this.