maas149848
Old Hand
Points: 336
More actions
April 11, 2011 at 5:29 pm
#248702
This server has very little activity.
Does anyone know what would cause this error?
Thanks!
Michael
G.Sudhagar
SSC Journeyman
Points: 85
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.
chandan_jha18
SSChampion
Points: 11330
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
Michael A. A. Schall-149848 (4/11/2011)
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