Friday, December 11, 2009
Could not obtain exclusive lock on database ‘Model’ « Systems Engineering and RDBMS
Could not obtain exclusive lock on database ‘Model’ « Systems Engineering and RDBMS: "In SQL Server, whenever a new user database is created, it takes it’s properties from the “model” database (this system database acts as a template for new user databases) and if there are over-rides to some of the parameters for the new user database, those are overridden based on what is specified in the create database script. SQL Server attempts to obtain an EXCLUSIVE lock on the model database during this process. This is to prevent other processes from updating the model database’s schema whilst the new database is being created, so that the new database’s schema is in a known, consistent state."
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment