Set default recovery model for databases to Simple - by way0utwest

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


14
2
Sign in
to vote
ID 559287 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 5/14/2010 4:08:23 PM
Access Restriction Public

Description

There are many people that setup SQL Server databases, and set up full backups, expecting that this will manage space. The default recovery model of full means that their transaction logs often grow to fill the disk. Setting this to simple would prevent countless service interruptions from people that do not understand the models.

Those that do would easily be able to set the model to full.
Sign in to post a comment.
Posted by Microsoft on 3/18/2011 at 10:59 AM
Hello,

Thank you for submitting this suggestion, but we're trying to clean house and remove items we feel we will likely not address given their priority relative to other items in our queue. We believe it is unlikely that we will address this suggestion, and so we are closing it as “won’t fix”.

This cleaning will help us focus on the high-priority items that we feel need to get done, and we hope that it help provide better clarity to you about the issues we will (and won't) address.

For this particular suggestion, we cannot default to SIMPLE because you can't do point-in-time recovery and the choice of recovery model should be handled by the DBA or application based on their requirements. We would rather err on side of caution than pick a model that will prevent disaster recovery.

--
Umachandar, SQL Programmability Team
Posted by Microsoft on 5/21/2010 at 11:34 AM
Thank you for providing this suggestion to the SQL Server team.

We have added this to the list of changes we'd consider for a future release of SQL Server.