SQL Search 2 placing lock on model

sheldonhullsheldonhull Posts: 35 Silver 1
edited July 4, 2016 5:49AM in SQL Search
Could not obtain exclusive lock on database 'model'. Retry the operation later.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

I looked at list of locks and identified
--Record N42
HostName:redacted
ProcesId:113
Program_Name:SQL Search Indexer                                                                                                              
dbid:3
DBNAME:model
ResourceType:Database
OBJID:0
OBJNAME:NULL
RequestMode:S: Shared
ReqStatus:Granted
ReqOwner:ExSession

This prevented SQL Compare 11 from creating new db based on the target destination until I waited for SQL Search to release lock.

Comments

Sign In or Register to comment.