Backup SQL Server DB on Network Drive Big Problem. Please help

Hi All,
I want to using T-SQL execute BACKUP DATABASE command job on the SQL
Server Agent. But, it occured the following error:
My Job Owner is "sa", Category is Database Maintenance
My execute command is ..
BACKUP DATABASE NorthWind TO DISK =
'\\servername\Backup\NorthWind.BAK'
The job failed. The Job was invoked by User Machine\Administrator.
The last step to run was step 1 (DBt Backup).
Please advise.Hi
Make sure that your SQL Server Services are running under a Domain Account
and that the user has correct permissions to the share.
To see the error message, run the T-SQL from Query Analyser.
Regards
Mike
"Kelvin" wrote:

> Hi All,
> I want to using T-SQL execute BACKUP DATABASE command job on the SQL
> Server Agent. But, it occured the following error:
> My Job Owner is "sa", Category is Database Maintenance
> My execute command is ..
> BACKUP DATABASE NorthWind TO DISK =
> '\\servername\Backup\NorthWind.BAK'
> The job failed. The Job was invoked by User Machine\Administrator.
> The last step to run was step 1 (DBt Backup).
> Please advise.
>|||Hi Mike,
How to check SQL Server Services are running under a Domain Account and
the user has correct permissions to the share. ' Please advise
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||1. On the SQL Server, go to Control Panel/Administrative Tools/Services
and make sure the MSSQLServer service is running under an account
"Domain\User" instead of Local Service.
2. Go to the share on the network drive and look at Sharing and Security to
make sure that same user has read/write permissions on the share. You can
probably have your network group do this for you.
"Tai Kelvin" <kelvinweb@.gmail.com> wrote in message
news:#OWSbgn7EHA.3696@.TK2MSFTNGP10.phx.gbl...
> Hi Mike,
>
> How to check SQL Server Services are running under a Domain Account and
> the user has correct permissions to the share. ' Please advise
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi Mike,
I checked that MSSQLServer service is running under Local Administrator
Account, and I also change the job owner to Local Administrator Account,
but it still occurs following error:
The job failed. The Job was invoked by User LocalMachine\Administrator.
The last step to run was step 1 (MyTesting Backup).
If the Backup Network Drive of PC just only running on Workgroup. How to
using T-SQL Backup Network Drive ?
Please advise.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||"Tai Kelvin" <kelvinweb@.gmail.com> wrote in message
news:eJsI9wu7EHA.2180@.TK2MSFTNGP12.phx.gbl...
> Hi Mike,
> I checked that MSSQLServer service is running under Local Administrator
> Account, and I also change the job owner to Local Administrator Account,
> but it still occurs following error:
> The job failed. The Job was invoked by User LocalMachine\Administrator.
Right. It can NOT run under a Local Administrator account.
It needs to be a domain account.

> The last step to run was step 1 (MyTesting Backup).
> If the Backup Network Drive of PC just only running on Workgroup. How to
> using T-SQL Backup Network Drive ?
You can TRY to give it a username and password that the computer containing
the network drive also has, but I'm not sure it would would work.

> Please advise.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi,
When I change the owner to "Domain Administrator" to execute the T-SQL
to backup database to the network drive.
It display the following error:
The job failed. Unable to determine if the owner (Domain\Administrator)
of job Test Backup has server access (reason: Could not obtain
information about Windows NT group/user 'Domain\Administrator'.
[SQLSTATE 42000] (Error 8198)).
But the Shared Network Drive PC haven't connect Domain, runing on
workgroup only. I can't directly to access that PC. Please advise.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Try to change the job owner to sa.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Tai Kelvin" <kelvinweb@.gmail.com> wrote in message news:ORQOrBy7EHA.3696@.TK2MSFTNGP10.phx.g
bl...
> Hi,
> When I change the owner to "Domain Administrator" to execute the T-SQL
> to backup database to the network drive.
> It display the following error:
> The job failed. Unable to determine if the owner (Domain\Administrator)
> of job Test Backup has server access (reason: Could not obtain
> information about Windows NT group/user 'Domain\Administrator'.
> [SQLSTATE 42000] (Error 8198)).
> But the Shared Network Drive PC haven't connect Domain, runing on
> workgroup only. I can't directly to access that PC. Please advise.
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi.. I try to using sa, but it is same result.
Please advise
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Did you get the exact same error message after changing job owner to "sa". T
hat would be strange, as
the error messages you posted referred to "Domain\Administrator"...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Tai Kelvin" <kelvinweb@.gmail.com> wrote in message news:uEl5LwC8EHA.3236@.TK2MSFTNGP15.phx.g
bl...
>
> Hi.. I try to using sa, but it is same result.
> Please advise
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

Backup SQL Server DB on Network Drive Big Problem. Please help

Hi All,
I want to using T-SQL execute BACKUP DATABASE command job on the SQL
Server Agent. But, it occured the following error:
My Job Owner is "sa", Category is Database Maintenance
My execute command is ..
BACKUP DATABASE NorthWind TO DISK =
'\\servername\Backup\NorthWind.BAK'
The job failed. The Job was invoked by User Machine\Administrator.
The last step to run was step 1 (DBt Backup).
Please advise.
Hi
Make sure that your SQL Server Services are running under a Domain Account
and that the user has correct permissions to the share.
To see the error message, run the T-SQL from Query Analyser.
Regards
Mike
"Kelvin" wrote:

> Hi All,
> I want to using T-SQL execute BACKUP DATABASE command job on the SQL
> Server Agent. But, it occured the following error:
> My Job Owner is "sa", Category is Database Maintenance
> My execute command is ..
> BACKUP DATABASE NorthWind TO DISK =
> '\\servername\Backup\NorthWind.BAK'
> The job failed. The Job was invoked by User Machine\Administrator.
> The last step to run was step 1 (DBt Backup).
> Please advise.
>
|||Hi Mike,
How to check SQL Server Services are running under a Domain Account and
the user has correct permissions to the share. ? Please advise
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||1. On the SQL Server, go to Control Panel/Administrative Tools/Services
and make sure the MSSQLServer service is running under an account
"Domain\User" instead of Local Service.
2. Go to the share on the network drive and look at Sharing and Security to
make sure that same user has read/write permissions on the share. You can
probably have your network group do this for you.
"Tai Kelvin" <kelvinweb@.gmail.com> wrote in message
news:#OWSbgn7EHA.3696@.TK2MSFTNGP10.phx.gbl...
> Hi Mike,
>
> How to check SQL Server Services are running under a Domain Account and
> the user has correct permissions to the share. ? Please advise
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi Mike,
I checked that MSSQLServer service is running under Local Administrator
Account, and I also change the job owner to Local Administrator Account,
but it still occurs following error:
The job failed. The Job was invoked by User LocalMachine\Administrator.
The last step to run was step 1 (MyTesting Backup).
If the Backup Network Drive of PC just only running on Workgroup. How to
using T-SQL Backup Network Drive ?
Please advise.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||"Tai Kelvin" <kelvinweb@.gmail.com> wrote in message
news:eJsI9wu7EHA.2180@.TK2MSFTNGP12.phx.gbl...
> Hi Mike,
> I checked that MSSQLServer service is running under Local Administrator
> Account, and I also change the job owner to Local Administrator Account,
> but it still occurs following error:
> The job failed. The Job was invoked by User LocalMachine\Administrator.
Right. It can NOT run under a Local Administrator account.
It needs to be a domain account.

> The last step to run was step 1 (MyTesting Backup).
> If the Backup Network Drive of PC just only running on Workgroup. How to
> using T-SQL Backup Network Drive ?
You can TRY to give it a username and password that the computer containing
the network drive also has, but I'm not sure it would would work.

> Please advise.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi,
When I change the owner to "Domain Administrator" to execute the T-SQL
to backup database to the network drive.
It display the following error:
The job failed. Unable to determine if the owner (Domain\Administrator)
of job Test Backup has server access (reason: Could not obtain
information about Windows NT group/user 'Domain\Administrator'.
[SQLSTATE 42000] (Error 8198)).
But the Shared Network Drive PC haven't connect Domain, runing on
workgroup only. I can't directly to access that PC. Please advise.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Try to change the job owner to sa.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Tai Kelvin" <kelvinweb@.gmail.com> wrote in message news:ORQOrBy7EHA.3696@.TK2MSFTNGP10.phx.gbl...
> Hi,
> When I change the owner to "Domain Administrator" to execute the T-SQL
> to backup database to the network drive.
> It display the following error:
> The job failed. Unable to determine if the owner (Domain\Administrator)
> of job Test Backup has server access (reason: Could not obtain
> information about Windows NT group/user 'Domain\Administrator'.
> [SQLSTATE 42000] (Error 8198)).
> But the Shared Network Drive PC haven't connect Domain, runing on
> workgroup only. I can't directly to access that PC. Please advise.
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi.. I try to using sa, but it is same result.
Please advise
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Did you get the exact same error message after changing job owner to "sa". That would be strange, as
the error messages you posted referred to "Domain\Administrator"...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Tai Kelvin" <kelvinweb@.gmail.com> wrote in message news:uEl5LwC8EHA.3236@.TK2MSFTNGP15.phx.gbl...
>
> Hi.. I try to using sa, but it is same result.
> Please advise
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

Backup SQL Server DB on Network Drive Big Problem. Please help

Hi All,
I want to using T-SQL execute BACKUP DATABASE command job on the SQL
Server Agent. But, it occured the following error:
My Job Owner is "sa", Category is Database Maintenance
My execute command is ..
BACKUP DATABASE NorthWind TO DISK = '\\servername\Backup\NorthWind.BAK'
The job failed. The Job was invoked by User Machine\Administrator.
The last step to run was step 1 (DBt Backup).
Please advise.Hi
Make sure that your SQL Server Services are running under a Domain Account
and that the user has correct permissions to the share.
To see the error message, run the T-SQL from Query Analyser.
Regards
Mike
"Kelvin" wrote:
> Hi All,
> I want to using T-SQL execute BACKUP DATABASE command job on the SQL
> Server Agent. But, it occured the following error:
> My Job Owner is "sa", Category is Database Maintenance
> My execute command is ..
> BACKUP DATABASE NorthWind TO DISK => '\\servername\Backup\NorthWind.BAK'
> The job failed. The Job was invoked by User Machine\Administrator.
> The last step to run was step 1 (DBt Backup).
> Please advise.
>sql

Backup SQL Server 2005

Hi,

I created a job to backup my database. Sometimes I get the following error:
The job failed. Unable to determine if the owner (DOMAIN\Administrator) of job Backup.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\Administrator'<c/> error code 0x54b. [SQLSTATE 42000] (Error 15404))

I already deleted the job and made it again. Same problem. I don't get that error every day. For example: I got it 4 times last month.

Does anybody know what I can do to resolve the error?This appears to be a problem with AD. I would guess the job is not able to authenticate itself, or query information from AD. That said, it REALLY a bad idea to run jobs as Domain Admin. You should use service accounts.

backup job

I have set up a scheduled backup job and the owner is set to john. The
scheduled backup job always failed no matter it manually run or scheduled. I
use query analyzer and login as john and copy the script from the job and
execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
anyone please tell me why the job run in query analyzer but not in Enterprse
Manager and how to fix it? Thanks.
What job step type? Is John an SQL Server or a Windows login? What exact error for the job? If you
define an output file for the jobstep, what error(s) do you see there?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>I have set up a scheduled backup job and the owner is set to john. The scheduled backup job always
>failed no matter it manually run or scheduled. I use query analyzer and login as john and copy the
>script from the job and execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
>anyone please tell me why the job run in query analyzer but not in Enterprse Manager and how to fix
>it? Thanks.
>
|||John is a SQL Server login and no windows login and it is assigned as system
administrator role in SQL server. When I looked at the job log in EM, it
said "failed to run at certain time". Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>
|||This is what I got from output file:
************************************************** ************************
Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08
09:28:00
Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'.
[SQLSTATE 08004]
Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
************************************************** *********************************
pure is the database I want to backup. The strange things I realized is that
John is the owner of the scheduled job but why guest user is involved in the
scheduled job according to the output file. Can you please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>
|||So it is a TSQL job step. What database is it defined to run in? Make sure it runs in the master
database and do *not* perform USE within the TSQL code. Always do your BACKUP and RESTORE from the
master database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:e7sxP35%23FHA.3908@.TK2MSFTNGP10.phx.gbl...
> This is what I got from output file:
> ************************************************** ************************
> Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08 09:28:00
> Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'. [SQLSTATE 08004]
> Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000]
> ************************************************** *********************************
> pure is the database I want to backup. The strange things I realized is that John is the owner of
> the scheduled job but why guest user is involved in the scheduled job according to the output
> file. Can you please help? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
>

backup job

I have set up a scheduled backup job and the owner is set to john. The
scheduled backup job always failed no matter it manually run or scheduled. I
use query analyzer and login as john and copy the script from the job and
execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
anyone please tell me why the job run in query analyzer but not in Enterprse
Manager and how to fix it? Thanks.What job step type? Is John an SQL Server or a Windows login? What exact error for the job? If you
define an output file for the jobstep, what error(s) do you see there?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>I have set up a scheduled backup job and the owner is set to john. The scheduled backup job always
>failed no matter it manually run or scheduled. I use query analyzer and login as john and copy the
>script from the job and execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
>anyone please tell me why the job run in query analyzer but not in Enterprse Manager and how to fix
>it? Thanks.
>|||John is a SQL Server login and no windows login and it is assigned as system
administrator role in SQL server. When I looked at the job log in EM, it
said "failed to run at certain time". Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>>I have set up a scheduled backup job and the owner is set to john. The
>>scheduled backup job always failed no matter it manually run or scheduled.
>>I use query analyzer and login as john and copy the script from the job
>>and execute it and IT RUN. OK, I change the job owner to sa and it runs.
>>Can anyone please tell me why the job run in query analyzer but not in
>>Enterprse Manager and how to fix it? Thanks.
>|||This is what I got from output file:
**************************************************************************
Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08
09:28:00
Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'.
[SQLSTATE 08004]
Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
***********************************************************************************
pure is the database I want to backup. The strange things I realized is that
John is the owner of the scheduled job but why guest user is involved in the
scheduled job according to the output file. Can you please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>>I have set up a scheduled backup job and the owner is set to john. The
>>scheduled backup job always failed no matter it manually run or scheduled.
>>I use query analyzer and login as john and copy the script from the job
>>and execute it and IT RUN. OK, I change the job owner to sa and it runs.
>>Can anyone please tell me why the job run in query analyzer but not in
>>Enterprse Manager and how to fix it? Thanks.
>|||So it is a TSQL job step. What database is it defined to run in? Make sure it runs in the master
database and do *not* perform USE within the TSQL code. Always do your BACKUP and RESTORE from the
master database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:e7sxP35%23FHA.3908@.TK2MSFTNGP10.phx.gbl...
> This is what I got from output file:
> **************************************************************************
> Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08 09:28:00
> Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'. [SQLSTATE 08004]
> Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000]
> ***********************************************************************************
> pure is the database I want to backup. The strange things I realized is that John is the owner of
> the scheduled job but why guest user is involved in the scheduled job according to the output
> file. Can you please help? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
>> What job step type? Is John an SQL Server or a Windows login? What exact error for the job? If
>> you define an output file for the jobstep, what error(s) do you see there?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> " -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>>I have set up a scheduled backup job and the owner is set to john. The scheduled backup job
>>always failed no matter it manually run or scheduled. I use query analyzer and login as john and
>>copy the script from the job and execute it and IT RUN. OK, I change the job owner to sa and it
>>runs. Can anyone please tell me why the job run in query analyzer but not in Enterprse Manager
>>and how to fix it? Thanks.
>>
>

backup job

I have set up a scheduled backup job and the owner is set to john. The
scheduled backup job always failed no matter it manually run or scheduled. I
use query analyzer and login as john and copy the script from the job and
execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
anyone please tell me why the job run in query analyzer but not in Enterprse
Manager and how to fix it? Thanks.What job step type? Is John an SQL Server or a Windows login? What exact err
or for the job? If you
define an output file for the jobstep, what error(s) do you see there?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl
..
>I have set up a scheduled backup job and the owner is set to john. The sch
eduled backup job always
>failed no matter it manually run or scheduled. I use query analyzer and log
in as john and copy the
>script from the job and execute it and IT RUN. OK, I change the job owner
to sa and it runs. Can
>anyone please tell me why the job run in query analyzer but not in Enterprs
e Manager and how to fix
>it? Thanks.
>|||John is a SQL Server login and no windows login and it is assigned as system
administrator role in SQL server. When I looked at the job log in EM, it
said "failed to run at certain time". Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>|||This is what I got from output file:
****************************************
**********************************
Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08
09:28:00
Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'.
[SQLSTATE 08004]
Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
****************************************
************************************
*******
pure is the database I want to backup. The strange things I realized is that
John is the owner of the scheduled job but why guest user is involved in the
scheduled job according to the output file. Can you please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>|||So it is a TSQL job step. What database is it defined to run in? Make sure i
t runs in the master
database and do *not* perform USE within the TSQL code. Always do your BACKU
P and RESTORE from the
master database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:e7sxP35%23FHA.3908@.TK2MSFTNGP10.phx.gbl..
.
> This is what I got from output file:
> ****************************************
**********************************
> Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08 09
:28:00
> Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure
'. [SQLSTATE 08004]
> Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
> ****************************************
**********************************
*********
> pure is the database I want to backup. The strange things I realized is th
at John is the owner of
> the scheduled job but why guest user is involved in the scheduled job acco
rding to the output
> file. Can you please help? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
>

Backup issuesPlease HEELP!

I am trying to run a backup job and it has fail the message I am getting is:

The job failed. Unable to determine if the owner (MAMSI\lwilliams) of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not obtain information about Windows NT group/user 'MAMSI\lwilliams'. [SQLSTATE 42000] (Error 8198)).

Is it stating that my user group in windows NT doesn't have the rights to run a backup on this server?

Please help!!!

LystraMy first guess would be that the account used to start the SQL Agent service isn't a domain admin, so the agent can't even see what permissions the MAMSI\lwilliams login has in the domain.

NT security is a tough nut to crack at first, mostly because there are so many levels to it. This makes it robust, but a bugger to figure out at first!

-PatP

Backup issues

Hi there
My SQL server backups are running as nicely as they used to. Recently I
got the following error:
Message: The job failed. The owner () of job DB Backup Job for DB
Maintenance Plan 'Daily Backup1' does not have server access.
I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
deleted the existing maintenance plans and created identical new ones
which worked fine for a couple of weeks. Now this error is back. What
exactly is causing this? Is there another way to fix it without deleting
and recreating these backup jobs?
Thanks
HamishTry setting the owner of the job to "sa", you can do that for the jobs that
Maint Plan creates.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%237GPzUzuGHA.4460@.TK2MSFTNGP04.phx.gbl...
> Hi there
> My SQL server backups are running as nicely as they used to. Recently I
> got the following error:
> Message: The job failed. The owner () of job DB Backup Job for DB
> Maintenance Plan 'Daily Backup1' does not have server access.
> I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
> deleted the existing maintenance plans and created identical new ones
> which worked fine for a couple of weeks. Now this error is back. What
> exactly is causing this? Is there another way to fix it without deleting
> and recreating these backup jobs?
> Thanks
> Hamish|||Tibor Karaszi wrote:
> Try setting the owner of the job to "sa", you can do that for the jobs
> that Maint Plan creates.
>
Really dumb question then, how do I do that?|||Edit the job. You find the jobs folder under SQL Server Agent.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%234cem93uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Tibor Karaszi wrote:
> Really dumb question then, how do I do that?

Backup issues

Hi there
My SQL server backups are running as nicely as they used to. Recently I
got the following error:
Message: The job failed. The owner () of job DB Backup Job for DB
Maintenance Plan 'Daily Backup1' does not have server access.
I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
deleted the existing maintenance plans and created identical new ones
which worked fine for a couple of weeks. Now this error is back. What
exactly is causing this? Is there another way to fix it without deleting
and recreating these backup jobs?
Thanks
HamishTry setting the owner of the job to "sa", you can do that for the jobs that Maint Plan creates.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%237GPzUzuGHA.4460@.TK2MSFTNGP04.phx.gbl...
> Hi there
> My SQL server backups are running as nicely as they used to. Recently I
> got the following error:
> Message: The job failed. The owner () of job DB Backup Job for DB
> Maintenance Plan 'Daily Backup1' does not have server access.
> I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
> deleted the existing maintenance plans and created identical new ones
> which worked fine for a couple of weeks. Now this error is back. What
> exactly is causing this? Is there another way to fix it without deleting
> and recreating these backup jobs?
> Thanks
> Hamish|||Tibor Karaszi wrote:
> Try setting the owner of the job to "sa", you can do that for the jobs
> that Maint Plan creates.
>
Really dumb question then, how do I do that?|||Edit the job. You find the jobs folder under SQL Server Agent.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%234cem93uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Tibor Karaszi wrote:
>> Try setting the owner of the job to "sa", you can do that for the jobs
>> that Maint Plan creates.
> Really dumb question then, how do I do that?