Wednesday, March 7, 2012

Log shipping and switching recovery modes

I'm a bit confused (a normal state).
With log shipping, is it possible to switch recovery mode from/to Full and
Bulk Logged to alleviate problems caused by reindexing/defragging?
Some documents appear to say Full recovery mode only for log shipping but
others say no problem with Bulk Logged.
PaulI just tested in my Pubs DB.
1; Set in Full mode.
2; Full Backup.
3; Set in BL mode.
4; TLog Backup.
5; Did a successful Restore.
Despite my 30 second test, Id highly recommend your doing lots of testing
before you implement anything like this.
ChrisR
"Paul Cahill" wrote:

> I'm a bit confused (a normal state).
> With log shipping, is it possible to switch recovery mode from/to Full and
> Bulk Logged to alleviate problems caused by reindexing/defragging?
> Some documents appear to say Full recovery mode only for log shipping but
> others say no problem with Bulk Logged.
> Paul
>
>|||Thanks Chris
Paul
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:20A96EA2-0684-42C7-9C75-952285D92C25@.microsoft.com...[vbcol=seagreen]
>I just tested in my Pubs DB.
> 1; Set in Full mode.
> 2; Full Backup.
> 3; Set in BL mode.
> 4; TLog Backup.
> 5; Did a successful Restore.
> Despite my 30 second test, Id highly recommend your doing lots of testing
> before you implement anything like this.
> --
> ChrisR
>
> "Paul Cahill" wrote:
>

No comments:

Post a Comment