Sunday 7 August 2011

Model db in SQL Server

"model" db is created by SQL Server default installation. This db works as a template for any new User databases created.

i.e if you set "Initial file size" attribute of "model" db to 100MB, any new databases created hence forth will have a default value of 100MB for data file size. Similarly any other attributes of database will be inherited from this "model" db.

No comments:

Post a Comment