SQL Server and default recovery model
Posted on 2011-10-17
I have a cutomer with a server with MS Sql 2005. The company is an accounting-firm, and the accounting software creates a new sql database for every company which the account-firm do the accounting... And for some reason the recovery model on all newly created databases are set to "Simple", but because of their backup-solution we have to change the recovery model to "Full". But we want to configure so that every database is created with the recovery model "Full" by default. I read somewhere that if we changed the model-database, and set recovery model to "Full", it would create all future databases with the same recovery model. But in my case it doesn't for some reason. Can anyone help me?