Currently we have a number of databases that are in full recovery model. This is a conscious decision.
We also run the transaction log backups every 15 minutes.
But we run the transaction log backups only during the hour when people work with the databases, that is between 7 in the morning until 8 in the evening.
My question is:
- On a technical level, is this a good practice or not?