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