Post reply

backup job failed

  • September 30, 2013 at 12:44 am

    #395579

    Hi ,

    my full,dataintegrity,index optimization jobs failed with the below error Ö

    Executed as user: NT AUTHORITY\SYSTEM. Database '****' is already open and can only have one user at a time. [SQLSTATE 42000] (Error 924) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

    Thanks

  • September 30, 2013 at 12:52 am

    #1654433

    u may first check if there is any Windows server level backup jobs running>??

    like,, BackupExec

  • September 30, 2013 at 1:15 am

    #1654439

    Thanks for the update >

    I dont have indepth knowledge on windows.could you please suugest me how to check windows server level backup is running ..

  • September 30, 2013 at 1:16 am

    #1654441

    Sounds as if your database is in single user mode.

    SELECT user_access_desc

    FROM master.sys.databases

    WHERE name = '****'

    John

  • September 30, 2013 at 4:10 am

    #1654476

    Thanksjohn ,,

    Dataabase in multiuser mode

  • September 30, 2013 at 4:45 am

    #1654484

    The message implies that the database was in single user mode at the time the backup tried to run. Check for other jobs setting it to single user, check in the error logs to see if someone set it to single user.

    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

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

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