Post reply

error 4060 on orphaned database

  • February 1, 2008 at 8:40 am

    #183670

    I have detached and later deleted several databases from a sql 2005 environment. Now I am getting an error for each database each minute that is as follows:

    Message

    [298] SQLServer Error: 4060, Cannot open database "DatabesNameHere" requested by the login. The login failed. [SQLSTATE 42000]

    How do I tell SQL they are gone and we need to move on?

    SQL Newby

    Susan

  • February 4, 2008 at 10:07 am

    #774814

    Sounds like something is still trying to use these DBs. Are they in maint plans or are they the default DB for anyone? Maybe there are still some things trying to hit them?

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

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

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