SQL Search 2 placing lock on model
sheldonhull 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.
1 · Share on Twitter
Thanks for your post!
I have logged a support ticket for you and will email you shortly.
Redgate Software Ltd.
E-mail: [email protected]