1

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.

2
  • Dan White's answer below is the correct one, but it's unclear if you want to force that on the client server or your server? The client may not let you modify the model database. Apr 27 '17 at 13:20
  • @JonathanFite We have SQL Server installed on the client tills. The new database will be created from model on the till instance.
    – cloudsafe
    Apr 27 '17 at 13:29
4

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.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.