Forum Replies Created

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

  • RE: Backups Failing as Scheduled jobs

    Both SQL Agent and MSSQLSERVER services start with the same account ..that account has local admin rights. Job is being run right at the server (remoting in using same account...

  • RE: Backups Failing as Scheduled jobs

    Sorry for the delay ...here's the script:

    -- Script generated on 7/21/2004 7:15 AM

    -- By: NTGROUP\mts_user

    -- Server: PCASRVR\PCA

    BEGIN TRANSACTION           

      DECLARE @JobID BINARY(16) 

      DECLARE @ReturnCode INT   

      SELECT @ReturnCode =...

  • RE: Backups Failing as Scheduled jobs

    tried that already ...that has same results. 

  • RE: Backups Failing as Scheduled jobs

    That's it in the log ...(last entry)

    job owner is mts_user (which is domain admin account, and also what the services start up as logon account)

    job history: The job failed.  The...

  • RE: Backups Failing as Scheduled jobs

    Okay ..user is Domain Admin ...is also local admin on server.  Has every priv. on db's.  Can run the backup from EM, can run a backup in QA ..just not...

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