Post reply

create database error

  • July 31, 2006 at 12:06 pm

    #113835

    ODBC SQLstate 42000

    Error-1807

    Could not be obtain exclusive lock on database 'MODEL'. Retry the operation later. CREATE DATABASE failed.Some file names listed could not be created. Check previous errors.

     

    When I try to create a database I am getting the above error.

    So how can I create a new DB by fixing the above issue.

     

    Thanks.

  • July 31, 2006 at 4:20 pm

    #652487

    It appears that you have one or more processes logged into the MODEL database.  Look at sp_who2 or in EM at current activity and find out who or what is logged into MODEL.  Kill the process or restart SQL Server to clear the connection.  You could use the 'Detach Database' option to clear the user connections (but don't follow through with the detach).

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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