Once we switched from SIMPLE Recovery model to FULL or BULK_LOGGED recovery model, what are all the recommendations ?

Posted by PandianS on 6/1/2011 | Category: Sql Server Interview questions | Views: 4830 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

1. After switched from SIMPLE recovery model to FULL or BULK_LOGGED recovery model, We should take the Data backup either FULL or DIFFERENTIAL backup, then only the LSN resets and Log chain starts..

2. Transaction Log backup should be scheduled, then only the committed transactions will be removed from the transaction log otherwise the Log grows and grows....... till reaches the physical free space.

Asked In: SQL DBA Interview Question | Alert Moderator