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 hang

Hi All,
I have a problem with the backup hang. I make a backup
through EM, completed + verified as well. It doesn't
matter what location I choose. For this example, I used
the default backup SQL location on the same drive.
When I try to restore the backup, it starts, but the
dialogbox did not show progress and it stays there for
ever. In the errorlog I have the error:
udopen: Operating system error 32(The process cannot
access the file because it is being used by another
process.) during the creation/opening of physical device
D:\MRE-DEV-SQL_data\MSSQL\Data\ENT_DATA.mdf.
2003-10-09 15:09:30.67 spid58 FCB::Open failed: Could
not open device D:\MRE-DEV-
SQL_data\MSSQL\Data\ENT_DATA.mdf for virtual device number
(VDN) 0.
What I could look at?
Thanks a lot for the help.Seems like you try to restore to a new database name but you don't specify for that database to be
created to use new filename, meaning that SQL Server tries to use the file names that are already in
use by the old database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"MJ" <MJ@.mjsql.com> wrote in message news:06b601c38f4d$f73930c0$a001280a@.phx.gbl...
> Hi All,
> I have a problem with the backup hang. I make a backup
> through EM, completed + verified as well. It doesn't
> matter what location I choose. For this example, I used
> the default backup SQL location on the same drive.
> When I try to restore the backup, it starts, but the
> dialogbox did not show progress and it stays there for
> ever. In the errorlog I have the error:
> udopen: Operating system error 32(The process cannot
> access the file because it is being used by another
> process.) during the creation/opening of physical device
> D:\MRE-DEV-SQL_data\MSSQL\Data\ENT_DATA.mdf.
> 2003-10-09 15:09:30.67 spid58 FCB::Open failed: Could
> not open device D:\MRE-DEV-
> SQL_data\MSSQL\Data\ENT_DATA.mdf for virtual device number
> (VDN) 0.
> What I could look at?
> Thanks a lot for the help.