Problems with backup

Hello;
I've problems with the differents data bases backups with SQL SERVER 2000.
If I launch the backup manualy of the differents data bases I have no
problem; but when I schedule the backup it fails show me in the event viewer
application this message:
Origen: SQLSERVERAGENT
Categoria: Job Engine
ID: 208
Descripción:
SQL Server Scheduled Job 'Copia de seguridad master'
(0xE038C2FDE1799C45ABB23A45F46B4BF4) - Status: Error - Invoked on:
2005-09-20 13:14:35 - Message: El trabajó falló. No se puede determinar si
el
propietario (Dominio\Usuario) del trabajo Copia de seguridad master tiene
acceso al servidor (motivo: No se puede conectar al servidor, compruebe los
registros de errores de SQL Server y del Agente SQL Server).
I'm spanish, and I have the spanish edtion, I will try to translate the
message.
Source: SQLSERVERAGENT
Category: Job Engine
ID: 208
Description:
SQL Server Scheduled Job 'Copia de seguridad master'
(0xE038C2FDE1799C45ABB23A45F46B4BF4) - Status: Error - Invoked on:
2005-09-20 13:14:35 - Message: The job fails. It can't determinate if the
property (Domain\User) of de job "Copia de seguridad master" have access to
de server (reasolt: It can't conect to the server, check the error log in SQL
Server and the SQL Server Agent)
This error ocours when I backup all the data bases, not only with the master
Thanks
P.Burguete wrote:
> Hello;
> I've problems with the differents data bases backups with SQL SERVER 2000.
> If I launch the backup manualy of the differents data bases I have no
> problem; but when I schedule the backup it fails show me in the event viewer
> application this message:
> Origen: SQLSERVERAGENT
> Categoria: Job Engine
> ID: 208
> Descripción:
> SQL Server Scheduled Job 'Copia de seguridad master'
> (0xE038C2FDE1799C45ABB23A45F46B4BF4) - Status: Error - Invoked on:
> 2005-09-20 13:14:35 - Message: El trabajó falló. No se puede determinar si
> el
> propietario (Dominio\Usuario) del trabajo Copia de seguridad master tiene
> acceso al servidor (motivo: No se puede conectar al servidor, compruebe los
> registros de errores de SQL Server y del Agente SQL Server).
> I'm spanish, and I have the spanish edtion, I will try to translate the
> message.
> Source: SQLSERVERAGENT
> Category: Job Engine
> ID: 208
> Description:
> SQL Server Scheduled Job 'Copia de seguridad master'
> (0xE038C2FDE1799C45ABB23A45F46B4BF4) - Status: Error - Invoked on:
> 2005-09-20 13:14:35 - Message: The job fails. It can't determinate if the
> property (Domain\User) of de job "Copia de seguridad master" have access to
> de server (reasolt: It can't conect to the server, check the error log in SQL
> Server and the SQL Server Agent)
> This error ocours when I backup all the data bases, not only with the master
> Thanks
>
Which account is used to run the SQL Server Agent service? This should
be a domain account that has access to the folders/servers where the
backup files is placed.
Regards
Steen
|||Hi,
Change the SQL Server Agent service startup account to an account which has
got previlages.
For testing purpose you can first change it to Local system account and
execute the scheduled task
and once u find every thing goes fine then change to a domain OS user which
has got prev. to backup
Thanks
Hari
SQL Server MVP
"P.Burguete" <PBurguete@.discussions.microsoft.com> wrote in message
news:FE7BC385-B6ED-4A63-980C-3500FB304739@.microsoft.com...
> Hello;
> I've problems with the differents data bases backups with SQL SERVER 2000.
> If I launch the backup manualy of the differents data bases I have no
> problem; but when I schedule the backup it fails show me in the event
> viewer
> application this message:
> Origen: SQLSERVERAGENT
> Categoria: Job Engine
> ID: 208
> Descripcin:
> SQL Server Scheduled Job 'Copia de seguridad master'
> (0xE038C2FDE1799C45ABB23A45F46B4BF4) - Status: Error - Invoked on:
> 2005-09-20 13:14:35 - Message: El trabaj fall. No se puede determinar
> si
> el
> propietario (Dominio\Usuario) del trabajo Copia de seguridad master tiene
> acceso al servidor (motivo: No se puede conectar al servidor, compruebe
> los
> registros de errores de SQL Server y del Agente SQL Server).
> I'm spanish, and I have the spanish edtion, I will try to translate the
> message.
> Source: SQLSERVERAGENT
> Category: Job Engine
> ID: 208
> Description:
> SQL Server Scheduled Job 'Copia de seguridad master'
> (0xE038C2FDE1799C45ABB23A45F46B4BF4) - Status: Error - Invoked on:
> 2005-09-20 13:14:35 - Message: The job fails. It can't determinate if the
> property (Domain\User) of de job "Copia de seguridad master" have access
> to
> de server (reasolt: It can't conect to the server, check the error log in
> SQL
> Server and the SQL Server Agent)
> This error ocours when I backup all the data bases, not only with the
> master
> Thanks
>
|||Try changing the job owner to sa. I think that this happens when Agent service account cannot access
enough info in domain to validate the Windows owner of the job. Setting the owner to a SQL Server
account should take care of that.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"P.Burguete" <PBurguete@.discussions.microsoft.com> wrote in message
news:FE7BC385-B6ED-4A63-980C-3500FB304739@.microsoft.com...
> Hello;
> I've problems with the differents data bases backups with SQL SERVER 2000.
> If I launch the backup manualy of the differents data bases I have no
> problem; but when I schedule the backup it fails show me in the event viewer
> application this message:
> Origen: SQLSERVERAGENT
> Categoria: Job Engine
> ID: 208
> Descripción:
> SQL Server Scheduled Job 'Copia de seguridad master'
> (0xE038C2FDE1799C45ABB23A45F46B4BF4) - Status: Error - Invoked on:
> 2005-09-20 13:14:35 - Message: El trabajó falló. No se puede determinar si
> el
> propietario (Dominio\Usuario) del trabajo Copia de seguridad master tiene
> acceso al servidor (motivo: No se puede conectar al servidor, compruebe los
> registros de errores de SQL Server y del Agente SQL Server).
> I'm spanish, and I have the spanish edtion, I will try to translate the
> message.
> Source: SQLSERVERAGENT
> Category: Job Engine
> ID: 208
> Description:
> SQL Server Scheduled Job 'Copia de seguridad master'
> (0xE038C2FDE1799C45ABB23A45F46B4BF4) - Status: Error - Invoked on:
> 2005-09-20 13:14:35 - Message: The job fails. It can't determinate if the
> property (Domain\User) of de job "Copia de seguridad master" have access to
> de server (reasolt: It can't conect to the server, check the error log in SQL
> Server and the SQL Server Agent)
> This error ocours when I backup all the data bases, not only with the master
> Thanks
>