Bulk logged recovery model and log backups

re: Bulk logged recovery model and log backups

BlackHawk — Fri, 10 Jul 2009 19:29:00 GMT

Tibor,

Is there any reason to use anything besides Bulk Logged if performing Log Shipping?

I would assume transaction log backups were being performed at a reasonable rate.

re: Bulk logged recovery model and log backups

TiborKaraszi — Sat, 11 Jul 2009 08:49:45 GMT

<<Is there any reason to use anything besides Bulk Logged if performing Log Shipping? >>

I prefer to only use bulk_logged when neccesary. IF you have the db in bulk_logged all the time, then any old SELECT INTO, small index creation, data load can result in you lose ability to:

1) restore the following log backup to point in time.

2) produce the following log backup in case data file is corrupt somehow.

I prefer to stay on top of above points and only switch down to bulk_logged when I really want this.

re: Bulk logged recovery model and log backups

Blackhawk — Mon, 13 Jul 2009 13:06:28 GMT

Thank you.

Clearest answer I have had to this question so far.

The index creation component really brought the whole thing to light.

Regards;

BlackHawk