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.
Paul
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:

> 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:

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...
>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:
>> 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
>>

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:
>

Log Shipping - switching recovery model in log shipping

Hi

I could not able to find Forums in regards to 'Log Shipping' thats why posting this question in here. Appriciate if someone can provide me answers depends on their experience.

Can we switch database recovery model when log shipping is turned on ?

We want to switch from Full Recovery to Bulk Logged Recovery to make sure Bulk Insert operations during the after hours load process will have some performance gain.

Is there any possibility of loosing data ?

Thanks

I think this will break the log chain and you may need to re-setup log-shipping.

You should try on a test system first.

Log Shipping - switching recovery model in log shipping

Hi

I could not able to find Forums in regards to 'Log Shipping' thats why posting this question in here. Appriciate if someone can provide me answers depends on their experience.

Can we switch database recovery model when log shipping is turned on ?

We want to switch from Full Recovery to Bulk Logged Recovery to make sure Bulk Insert operations during the after hours load process will have some performance gain.

Is there any possibility of loosing data ?

Thanks

I think this will break the log chain and you may need to re-setup log-shipping.

You should try on a test system first.