tag:blogger.com,1999:blog-4583365003930185416.post2814006366737988768..comments2024-01-29T01:48:06.546-06:00Comments on World of Whatever: Make it simple (recovery mode)Bill Fellowshttp://www.blogger.com/profile/09363163555016521189noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4583365003930185416.post-15498701592925380982013-02-04T09:45:48.767-06:002013-02-04T09:45:48.767-06:00I worked in a place where the production databases...I worked in a place where the production databases were all full without tlog backups...luckily they had not had a lot of data volume so no real problems arose before I noticed it...<br /><br />One of our standard build procedures for all new SQL servers but particularly dev or test environment servers, is to immediately switch the recovery model of the model database to simple. It defaults to full, and I would rather someone make the conscious decision that they need full recovery model (and therefore know also to instigate tlog backups) than, what is more often the case, they just create a bunch of dbs with no thought to recovery model or backups and the transaction log goes absolutely insane over time...SQLFunkateerhttps://www.blogger.com/profile/17237309391300543602noreply@blogger.com