How can we help you today? How can we help you today?

SQL Search 2 placing lock on model

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.
sheldonhull
0

Comments

1 comment

Sort by
  • Anu D
    Hi Sheldon,

    Thanks for your post!

    I have logged a support ticket for you and will email you shortly.
    Anu D
    0

Add comment

Please sign in to leave a comment.