Post reply

Error: Unspecified error occurred on SQL Server

  • January 21, 2009 at 2:19 am

    #198874

    Hi All,

    I have job in sql server which restores database backup and permissions thereafter.

    Sometime one step in this job fails with below message. This step restores users permissions on the restored database.

    Message

    Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0). The step failed.

    Please help...I don't find any specific error message in log file also.

  • January 22, 2009 at 6:55 am

    #931127

    I have known unhelpful messages but this has gotta be the worst

    no advice from me, but a certain amount of moral support

  • January 22, 2009 at 7:12 am

    #931141

    Nothing in the SQL error log at all?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 2, 2009 at 1:26 am

    #1073684

    The same situation, and really, nothing at all on this errorlog instance msg.

    Except one thing: when the process of restoring started, the sqlagent log contains the following msg till the end of restoring:

    2009-11-01 12:30:02 - ! [298] SQLServer Error: 18456, Login failed for user 'DIAMOND\sqladmin64'. [SQLSTATE 28000]

    2009-11-01 12:30:02 - ! [298] SQLServer Error: 4060, Cannot open database "bankDoc" requested by the login. The login failed. [SQLSTATE 42000]

  • November 2, 2009 at 1:30 am

    #1073686

    Guys, I found the culprit.

    One script in a job was kiiling connections. That was useless script :).

    Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

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