MSSQL 8 , job error over network location

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

MSSQL 8 , job error over network location

Author

Topic

kouliscon
Starting Member

7 Posts

Posted - 2011-08-01 : 05:25:46

Hello All

At my SERVER1 i log on as local Administrator and i enter to MSSMS 8 with windows authentication.

After i go to Windows Services and i stop the MS SQL SERVER service and i change the LOG ON to be with a DOMAIN USER who has Domain Admin rights.

The directory to another server2 has sharing fulll to everyone and security to have full to Domain ADmins and everyone.

At my MS Server Management Studio 8 i have created at SERVER OBJECTS -> BACKUP DEVICES a new backup device "Backup1" which make backup to \\192.168.10.7\sql\server1\ and creates the file file.bak.

If i run BACKUP UP DATABASE it will work fine.
I go to my Server Object-> backup devices->Backup1 and i say SCRIPT DEVICE AS-> CREAT TO-> AGENT JOB and i create the job called "1".

I go to SQL SERVER AGENT JOB i found my job called "1" and i press right button and choose START JOB STEP AT and runs the job but i have the following error:

SQL Server Scheduled Job '1' (0x0AB44AEFC9A64140998FDC1C92AD3293) - Status: Failed - Invoked on: 2011-08-01 11:04:12 - Message: The job failed. The Job was invoked by User SERVER1\Administrator. The last step to run was step 1 (1).

If i go to proprieties of job "1" and i change owner to DOMAINAME\DOMAIN ADMINS then i have the following error:

SQL Server Scheduled Job '1' (0x0AB44AEFC9A64140998FDC1C92AD3293) - Status: Failed - Invoked on: 2011-08-01 11:06:46 - Message: The job failed. The owner (DOMAINAMES\Domain Admins) of job 1 does not have server access.

Any suggestions?
thx in advance

Kostas

kouliscon
Starting Member

7 Posts

Posted - 2011-08-01 : 09:17:32

Hello

i found the solution:

i went to the already defined BACKUP DEVICE and there i just said to SCRIPT ACTION TO JOB.
Followed the steps and it worked :)

thank you all

Kostas

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources