Our technicians regularly go to client sites to fix EPOS tills. Sometimes they create a new database and import the objects and data via a sync.
Ideally, I'd like to force all new SQL Server 2012 databases to default to our particular initial size and autogrowth settings, not the 4Mb out of the box. The sync routines are executables so we can't rewrite them to apply ALTER DATABASE and our technicians aren't always proficient in SQL Server.
Is there any way to reconfigure the new database defaults? I thought there could be something by tweaking the system tables but can't get anywhere.
Best Answer
For lack of a better description. Model is copied to create new databases. This ensure they have the same collation, size, data growth settings, and any other parameter you want to set.