Enable User Selection of MS SQL Recovery Model: Full or Simple
To prevent the transaction log from continuously expanding with no clear method of truncation even after a full backup, it's a good idea to allow the user to select the recovery model (either Full or Simple) when creating the MS SQL database.
By enabling users to select the appropriate recovery model based on their recovery needs, those who do not require complete transaction log restoration can benefit from the simplicity and efficiency of the Simple recovery model, and keep transactions log to it's minimum size.
2
votes
Vassilios
shared this idea
Thank you for your suggestion. We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.
-- KvD