Post reply

Can not create new database. Error: Could not obtain exclusive lock on database model. Retry the operation later.

  • April 11, 2011 at 5:29 pm

    #248702

    This server has very little activity.

    Does anyone know what would cause this error?

    Thanks!

    Michael

  • April 11, 2011 at 11:19 pm

    #1310209

    HI,

    Make sure "Model" database is not in use by another user or session (as default DB) because model Db is use as template to create new DB. SQl server need to have exculisve lock on model Db to initialize the database and its metadata.

  • April 20, 2011 at 1:14 am

    #1313756

    Michael A. A. Schall-149848 (4/11/2011)

    This server has very little activity.

    Does anyone know what would cause this error?

    Thanks!

    Michael

    Use activity monitor or run sp_who2 to find out if there is a process causing model to be locked. It is not very common to see such a thing.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply