Problem with a job

2 Jul 2005 9:10 PM

Mark

Hi - I have a really simple job I want to run:

BACKUP DATABASE dbusers TO DISK =
"D:\SQLServerBackups\users\dbusers.bak"

...but it fails. There is nothing in the EM log files - is there
somewhere else (other logs) which will let me know why it's failing? Is
there a SQL Server Agent ID that needs permissions to the directory I'm
backing up to?

Thanks for any help,

Mark

*** Sent via Developersdex http://www.developersdex.com ***

2 Jul 2005 9:47 PM

oj

msdb..sysjobhistory table might give you a hint as to why the job failed.

Perhaps, your agent proxy is not setup correctly.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsql...

Also, be aware that SP3 has added a new flag. You might have to set it to
your environment.

e.g.
--restrict to admin only. 1=yes, 0=no
EXECUTE msdb..sp_set_sqlagent_properties @sysadmin_only = 0
go

--
-oj

Show quote

"Mark" <anonym***@devdex.com> wrote in message
news:O$RnDq0fFHA.2472@TK2MSFTNGP15.phx.gbl...
> Hi - I have a really simple job I want to run:
>
> BACKUP DATABASE dbusers TO DISK =
> "D:\SQLServerBackups\users\dbusers.bak"
>
> ..but it fails. There is nothing in the EM log files - is there
> somewhere else (other logs) which will let me know why it's failing? Is
> there a SQL Server Agent ID that needs permissions to the directory I'm
> backing up to?
>
> Thanks for any help,
>
> Mark
>
> *** Sent via Developersdex http://www.developersdex.com ***

2 Jul 2005 9:50 PM

Andrew J. Kelly

If you right click on the job in EM and choose View History you will see
information about each time it ran. You may have to check the checkbox that
says to show details to see the actual step information. Does this command
run from QA? Please note that all backups are run under the account SQL
Server runs under. So make sure that account has the correct permissions to
that drive. If it is a mapped drive you should use UNC pathing instead.

--
Andrew J. Kelly SQL MVP

Show quote

"Mark" <anonym***@devdex.com> wrote in message
news:O$RnDq0fFHA.2472@TK2MSFTNGP15.phx.gbl...
> Hi - I have a really simple job I want to run:
>
> BACKUP DATABASE dbusers TO DISK =
> "D:\SQLServerBackups\users\dbusers.bak"
>
> ..but it fails. There is nothing in the EM log files - is there
> somewhere else (other logs) which will let me know why it's failing? Is
> there a SQL Server Agent ID that needs permissions to the directory I'm
> backing up to?
>
> Thanks for any help,
>
> Mark
>
> *** Sent via Developersdex http://www.developersdex.com ***