Backup SQL Server Failures

I get the following errors when I use a maintenance plan to backup all of my databases on one of our servers. Note: When I run them manually they work as long as I put them in a different place on the same drive. The Everone group has full access on the NTFS drive that this is writing to so it can't be a rights issue. Also some of my databases are backed up while others fail. The account that I'm using to back these up is an administrator of the machine, I'm using the same account when I automate them through a maintenance plan that I do for doing them manually. The E:\ drive (where these are trying to be backed up) is Raid 5 with 30 gb free and 30gb used. These backups would only take up about 5gb of space (if they would work).

Please help!!!

BACKUP failed to complete the command BACKUP LOG [WebLogs] TO DISK = N'E:\SQLBackups\WebLogs\WebLogs_tlog_200304180731. TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Internal I/O request 0x2E0CB728: Op: Write, pBuffer: 0x17D20000, Size: 983040, Position: 328286720, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x13914200, OffsetHigh: 0x0, m_buf: 0x17D20000, m_len: 983040, m_actualBytes: 0, m_errcode: 2, BackupFile: E:\SQLBackups\WebLogs\WebLogs_tlog_200304180731.TR N

BackupMedium::ReportIoError: write failure on backup device 'E:\SQLBackups\WebLogs\WebLogs_tlog_200304180731.T RN'. Operating system error 2(The system cannot find the file specified.).Try to redefine the Maint.plan and also try using BACKUP LOG statement individually for this database.|||Thanks for your reply.

I've redefined my Maintenance Plan several times, as you could imagine, but to no avail.

Also, I've ran the BACKUP LOG statement on all of my databases in the place of the maintenance plan and received the same error.|||What is the SP[service pack] level on the SQL Server & OS?|||Windows 2000 Server SP3

SQL Server 2000 SP3 (Standard Edition not Enterprise)|||Then how about RECOVERY MODEL on these DBs.|||All of the user databases on this server have the Recovery Model option set to FULL.|||Looks like issues with NTFS permissions, check whether the SQL Services have necessary privileges and also under REGISTRY keys for these accounts.|||Since this is an internal machine and not our Internet SQL Server, the SQL Server Services (Main, Agent, etc.) all run under an account that is an administrator of the machine.

Security rights for both logical drives on the machine have the Everyone group having all rights locally. (The network shares only allow administrators in)|||As you'd mentioned the disk is 60GB, whereas 30Gb is free and another 30 is used.

Could you point out exact size of databases and free space available on the disk. It looks like when the Maint.plan is running typically the error refers to Free space on the server.

For a test try to redesing maint.plan for each database and see the results.|||The drive has 21.0 GB used. It has 38.7 GB free.

There are 16 databases to be backed up. The error happens randomly upon the 3 largest databases.

Email database = 263.88 mb (data and log)
ESP database = 316.25 mb (data and log)
WebLogs database = 5,069.76 gb (data and log)

(note 5 datafiles in the WebLogs and one log file... low amount of transactions and the database and the log is shrunk periodically throughout the day. We backup and truncate the log after a main import process is executed each day.)

I've ran the backup by hand using BACKUP DATABASE and it seldom works on these databases. Sometimes it will actually complete, others it doesn't. Also, the WebLogs database never completes and it always seems to fail at 24 percent (stats = 1 on the backup database command).

The backup log doesn't work at all on these databases whether I run it by hand or through the maintenance plan.|||Sorry for wasting your time.

I finally became fed up and went throught the security check points and actually went to the physical machine and looked in the event viewer of windows.

There I found that one of the Raid disks was going bad. That explains a lot.

Thanks for all of your help.

You had a lot of great ideas. If I had the ability to "dial in" to the machine, I would have spotted the problem much earlier.

I'm betting you agree that a bad disk could cause all of the quirky backup errors?|||Dont' be sorry.... Glad to hear your resolution and efforts, keep it up.
No second thought for these failures, but anytime if you've them again then follow the listings above.

Good luck.

backup speed SQL 2000

I'm running a manually written nightly backup script on all dbs on a
server. it's a dev server FYI.
the script does the following for all databases:
dbcc checkdb
dbcc dbreindex (on all relevant tables) -- this is done once a week
only
backup transaction with no_log
backup database
now... the duration for this is around 2 hours, given the number &
size of the databases. however, on the night I do the dbcc dbreindex,
the duration drops to 5 minutes. i've added the dbcc dbreindex to run
on other nights, and yes it drops down to 5 minutes each time. next
time it runs without, back up to 2 hours.....
why?
if any other info is required, i will supply.
Specify an output file and check for error messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<bmwbase-newsgroup@.yahoo.com> wrote in message
news:1179959856.718711.314480@.x35g2000prf.googlegr oups.com...
> I'm running a manually written nightly backup script on all dbs on a
> server. it's a dev server FYI.
> the script does the following for all databases:
> dbcc checkdb
> dbcc dbreindex (on all relevant tables) -- this is done once a week
> only
> backup transaction with no_log
> backup database
> now... the duration for this is around 2 hours, given the number &
> size of the databases. however, on the night I do the dbcc dbreindex,
> the duration drops to 5 minutes. i've added the dbcc dbreindex to run
> on other nights, and yes it drops down to 5 minutes each time. next
> time it runs without, back up to 2 hours.....
> why?
> if any other info is required, i will supply.
>

backup speed SQL 2000

I'm running a manually written nightly backup script on all dbs on a
server. it's a dev server FYI.
the script does the following for all databases:
dbcc checkdb
dbcc dbreindex (on all relevant tables) -- this is done once a week
only
backup transaction with no_log
backup database
now... the duration for this is around 2 hours, given the number &
size of the databases. however, on the night I do the dbcc dbreindex,
the duration drops to 5 minutes. i've added the dbcc dbreindex to run
on other nights, and yes it drops down to 5 minutes each time. next
time it runs without, back up to 2 hours.....
why?
if any other info is required, i will supply.Specify an output file and check for error messages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<bmwbase-newsgroup@.yahoo.com> wrote in message
news:1179959856.718711.314480@.x35g2000prf.googlegroups.com...
> I'm running a manually written nightly backup script on all dbs on a
> server. it's a dev server FYI.
> the script does the following for all databases:
> dbcc checkdb
> dbcc dbreindex (on all relevant tables) -- this is done once a week
> only
> backup transaction with no_log
> backup database
> now... the duration for this is around 2 hours, given the number &
> size of the databases. however, on the night I do the dbcc dbreindex,
> the duration drops to 5 minutes. i've added the dbcc dbreindex to run
> on other nights, and yes it drops down to 5 minutes each time. next
> time it runs without, back up to 2 hours.....
> why?
> if any other info is required, i will supply.
>sql

backup speed SQL 2000

I'm running a manually written nightly backup script on all dbs on a
server. it's a dev server FYI.
the script does the following for all databases:
dbcc checkdb
dbcc dbreindex (on all relevant tables) -- this is done once a week
only
backup transaction with no_log
backup database
now... the duration for this is around 2 hours, given the number &
size of the databases. however, on the night I do the dbcc dbreindex,
the duration drops to 5 minutes. i've added the dbcc dbreindex to run
on other nights, and yes it drops down to 5 minutes each time. next
time it runs without, back up to 2 hours.....
why?
if any other info is required, i will supply.Specify an output file and check for error messages.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<bmwbase-newsgroup@.yahoo.com> wrote in message
news:1179959856.718711.314480@.x35g2000prf.googlegroups.com...
> I'm running a manually written nightly backup script on all dbs on a
> server. it's a dev server FYI.
> the script does the following for all databases:
> dbcc checkdb
> dbcc dbreindex (on all relevant tables) -- this is done once a week
> only
> backup transaction with no_log
> backup database
> now... the duration for this is around 2 hours, given the number &
> size of the databases. however, on the night I do the dbcc dbreindex,
> the duration drops to 5 minutes. i've added the dbcc dbreindex to run
> on other nights, and yes it drops down to 5 minutes each time. next
> time it runs without, back up to 2 hours.....
> why?
> if any other info is required, i will supply.
>

backup problem

Hello,

This backup plan i have that works fine when i trigger it manually does not work when scheduled, here is the output of the error I am getting, I am new to sql 2005 and i really need to get this working fast, and dont have alot of time to research the problem right now.

Tdar

Error Message:

05/12/2007 00:00:01,daily backup.Subplan_1,Error,1,IPDDFZ2363ATL2,daily backup.Subplan_1,Subplan_1,,Executed as user: IPDDFZ2363ATL2\MSSQL_USER. ...42.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:00:01 AM Error: 2007-05-12 00:00:20.92 Code: 0xC00291EC Source: {C4C38724-5AEF-4472-9CC9-E24587B74591} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2007-05-12 00:00:20.93 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded<c/> but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2007-05-12 00:00:21.51 Code: 0xC0024104 Source: Back Up Database (Full) ... The package execution fa... The step failed.,00:00:20,0,0,,,,0
05/11/2007 00:00:00,daily backup.Subplan_1,Error,0,IPDDFZ2363ATL2,daily backup.Subplan_1,(Job outcome),,The job failed. The Job was invoked by Schedule 3 (BACKTEST). The last step to run was step 1 (Subplan_1).,00:00:15,0,0,,,,0

Typically, when you are able to run something (espeically DTS) by hand but it fails to work when you schedule it, it is a permissions issue. Check to see which user the job is running under and give that user the permission to execute what needs to be executed.

Tim

backup not working

In Enterprise Manager, I created a schedule to backup the
database. But the database is not being backed up.
I am able to manually take backup of my database.
What is the best option to take complete backup.
Should I append to the media or overwrite?
Thank you in advance,
LindaDo you have Server Agent runing?
Bojidar Alexnadrov|||Hi,
Check "SQLServer Agent" service is running. If not start the service and
check if the schedule is working.
What is the best option to take complete backup. Should I append to the
media or overwrite?
Both options are fine, But due to hard disk space limitations mostly people
choose the overwrite options (WITH INIT).
But ensure that old backup file is copied / moved to a remote hard disk or
Tape before overwriting.
Thanks
Hari
MCDBA
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:1931e01c44ca6$7bc051a0$a501280a@.phx.gbl...
> In Enterprise Manager, I created a schedule to backup the
> database. But the database is not being backed up.
> I am able to manually take backup of my database.
> What is the best option to take complete backup.
> Should I append to the media or overwrite?
> Thank you in advance,
> Linda|||Linda,
Answers inline.
Linda wrote:
> In Enterprise Manager, I created a schedule to backup the
> database. But the database is not being backed up.
> I am able to manually take backup of my database.
Is SQL Server Agent running? Do you get any errors? What does the
history for the job say?
> What is the best option to take complete backup.
> Should I append to the media or overwrite?
Depends. If backing up to disk I like to create a new file each time and
not overwrite the previous, or append. If going directly to tape you may
wish to append. What are you doing?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html|||Hari,
Thank you very much for your reply!
It works now.
-Linda
>--Original Message--
>Hi,
>Check "SQLServer Agent" service is running. If not start
the service and
>check if the schedule is working.
>What is the best option to take complete backup. Should
I append to the
>media or overwrite?
>Both options are fine, But due to hard disk space
limitations mostly people
>choose the overwrite options (WITH INIT).
>But ensure that old backup file is copied / moved to a
remote hard disk or
>Tape before overwriting.
>Thanks
>Hari
>MCDBA
>
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1931e01c44ca6$7bc051a0$a501280a@.phx.gbl...
>> In Enterprise Manager, I created a schedule to backup
the
>> database. But the database is not being backed up.
>> I am able to manually take backup of my database.
>> What is the best option to take complete backup.
>> Should I append to the media or overwrite?
>> Thank you in advance,
>> Linda
>
>.
>|||Mark,
Thank you very much for your reply! The agent wasn't up.
It works now.
-Linda
>--Original Message--
>Linda,
>Answers inline.
>
>Linda wrote:
>> In Enterprise Manager, I created a schedule to backup
the
>> database. But the database is not being backed up.
>> I am able to manually take backup of my database.
>Is SQL Server Agent running? Do you get any errors? What
does the
>history for the job say?
>> What is the best option to take complete backup.
>> Should I append to the media or overwrite?
>Depends. If backing up to disk I like to create a new
file each time and
>not overwrite the previous, or append. If going directly
to tape you may
>wish to append. What are you doing?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>.
>|||Bojidar,
Thank you very much for your reply! The Agent wasn't
running. It works now.
-Linda
>--Original Message--
>Do you have Server Agent runing?
>Bojidar Alexnadrov
>
>.
>

backup not working

In Enterprise Manager, I created a schedule to backup the
database. But the database is not being backed up.
I am able to manually take backup of my database.
What is the best option to take complete backup.
Should I append to the media or overwrite?
Thank you in advance,
Linda
Do you have Server Agent runing?
Bojidar Alexnadrov
|||Hi,
Check "SQLServer Agent" service is running. If not start the service and
check if the schedule is working.
What is the best option to take complete backup. Should I append to the
media or overwrite?
Both options are fine, But due to hard disk space limitations mostly people
choose the overwrite options (WITH INIT).
But ensure that old backup file is copied / moved to a remote hard disk or
Tape before overwriting.
Thanks
Hari
MCDBA
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:1931e01c44ca6$7bc051a0$a501280a@.phx.gbl...
> In Enterprise Manager, I created a schedule to backup the
> database. But the database is not being backed up.
> I am able to manually take backup of my database.
> What is the best option to take complete backup.
> Should I append to the media or overwrite?
> Thank you in advance,
> Linda
|||Linda,
Answers inline.
Linda wrote:
> In Enterprise Manager, I created a schedule to backup the
> database. But the database is not being backed up.
> I am able to manually take backup of my database.
Is SQL Server Agent running? Do you get any errors? What does the
history for the job say?

> What is the best option to take complete backup.
> Should I append to the media or overwrite?
Depends. If backing up to disk I like to create a new file each time and
not overwrite the previous, or append. If going directly to tape you may
wish to append. What are you doing?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||Hari,
Thank you very much for your reply!
It works now.
-Linda

>--Original Message--
>Hi,
>Check "SQLServer Agent" service is running. If not start
the service and
>check if the schedule is working.
>What is the best option to take complete backup. Should
I append to the
>media or overwrite?
>Both options are fine, But due to hard disk space
limitations mostly people
>choose the overwrite options (WITH INIT).
>But ensure that old backup file is copied / moved to a
remote hard disk or
>Tape before overwriting.
>Thanks
>Hari
>MCDBA
>
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1931e01c44ca6$7bc051a0$a501280a@.phx.gbl...
the
>
>.
>
|||Mark,
Thank you very much for your reply! The agent wasn't up.
It works now.
-Linda
[vbcol=seagreen]
>--Original Message--
>Linda,
>Answers inline.
>
>Linda wrote:
the
>Is SQL Server Agent running? Do you get any errors? What
does the
>history for the job say?
>
>Depends. If backing up to disk I like to create a new
file each time and
>not overwrite the previous, or append. If going directly
to tape you may
>wish to append. What are you doing?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>.
>
|||Bojidar,
Thank you very much for your reply! The Agent wasn't
running. It works now.
-Linda

>--Original Message--
>Do you have Server Agent runing?
>Bojidar Alexnadrov
>
>.
>

backup not working

In Enterprise Manager, I created a schedule to backup the
database. But the database is not being backed up.
I am able to manually take backup of my database.
What is the best option to take complete backup.
Should I append to the media or overwrite?
Thank you in advance,
LindaDo you have Server Agent runing?
Bojidar Alexnadrov|||Hi,
Check "SQLServer Agent" service is running. If not start the service and
check if the schedule is working.
What is the best option to take complete backup. Should I append to the
media or overwrite?
Both options are fine, But due to hard disk space limitations mostly people
choose the overwrite options (WITH INIT).
But ensure that old backup file is copied / moved to a remote hard disk or
Tape before overwriting.
Thanks
Hari
MCDBA
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:1931e01c44ca6$7bc051a0$a501280a@.phx
.gbl...
> In Enterprise Manager, I created a schedule to backup the
> database. But the database is not being backed up.
> I am able to manually take backup of my database.
> What is the best option to take complete backup.
> Should I append to the media or overwrite?
> Thank you in advance,
> Linda|||Linda,
Answers inline.
Linda wrote:
> In Enterprise Manager, I created a schedule to backup the
> database. But the database is not being backed up.
> I am able to manually take backup of my database.
Is SQL Server Agent running? Do you get any errors? What does the
history for the job say?

> What is the best option to take complete backup.
> Should I append to the media or overwrite?
Depends. If backing up to disk I like to create a new file each time and
not overwrite the previous, or append. If going directly to tape you may
wish to append. What are you doing?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html|||Hari,
Thank you very much for your reply!
It works now.
-Linda

>--Original Message--
>Hi,
>Check "SQLServer Agent" service is running. If not start
the service and
>check if the schedule is working.
>What is the best option to take complete backup. Should
I append to the
>media or overwrite?
>Both options are fine, But due to hard disk space
limitations mostly people
>choose the overwrite options (WITH INIT).
>But ensure that old backup file is copied / moved to a
remote hard disk or
>Tape before overwriting.
>Thanks
>Hari
>MCDBA
>
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1931e01c44ca6$7bc051a0$a501280a@.phx
.gbl...
the[vbcol=seagreen]
>
>.
>|||Mark,
Thank you very much for your reply! The agent wasn't up.
It works now.
-Linda

>--Original Message--
>Linda,
>Answers inline.
>
>Linda wrote:
the[vbcol=seagreen]
>Is SQL Server Agent running? Do you get any errors? What
does the
>history for the job say?
>
>Depends. If backing up to disk I like to create a new
file each time and
>not overwrite the previous, or append. If going directly
to tape you may
>wish to append. What are you doing?
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>.
>|||Bojidar,
Thank you very much for your reply! The Agent wasn't
running. It works now.
-Linda

>--Original Message--
>Do you have Server Agent runing?
>Bojidar Alexnadrov
>
>.
>

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...
>