November 6, 2008 at 1:39 pm
altered a job to backup the transaction log for a new database.
The job appears to run. In the sql log it appears that all the
transaction logs for the databases have been backed up.
I do not se any errors. But I am getting notified that the job failed.
SQLServer 2005 SP2.
Also I am new to sqlserver, where do I find information regarding
the system tables that I might want to query to find information
regarding backups?
Thanks,
Maris
November 6, 2008 at 1:44 pm
try to query the system tables like dbo.backupfile and dbo.backupset on the msdb database.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 6, 2008 at 5:03 pm
Please post the error message or the message under job step history here so that we can guess something out of it.
MJ
November 7, 2008 at 5:38 am
here is the message from the Job History.
Message
The job failed. The Job was invoked by Schedule 3 (mpHour_General.Subplan). The last step to run was step 1 (Subplan).
Message
Executed as user: UIS\SQLCSPROD01-SQLAdmin. ...042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:45:00 PM Progress: 2008-11-06 17:45:04.06 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [CCSAcctNum] TO DISK = N'T:\SQLBackups".: 100% complete End Progress Progress: 2008-11-06 17:45:04.17 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [fsaATLAS] TO DISK = N'T:\SQLBackups\f".: 100% complete End Progress Progress: 2008-11-06 17:45:04.23 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [GiveToKent] TO DISK = N'T:\SQLBackups".: 100% complete End Progress Progress: 2008-11-06 17:45:04.31 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [Gmail_optin] TO DISK = N'T:\SQLBackup".: 100% complete End Progress Progress: 2008-11-06 17:45:04.37 Source: Back Up Database (Transaction Log) ... The package execution fa... The step failed.
November 7, 2008 at 8:21 am
more Information:
Sql Security Patch 954606 was applied on 11/2
Started getting notified that the SQLServer: Buffer Manger was
below the threshold of 90.00.
checking the perfmon on the server shows that the buffer hit ratio
is maintained well over 90%.
Thursday I edited two maintenance plans.
One for the thransaction log backup & one for the daily backups.
now I am getting notified that the jobs failed when they execute. But when I check the sql logs, it appears that the backups are complete.
For example:
When last nights full backup was run. I was notified by e-mail
that the job failed. But when I checked the sqlserver log the
backups completed for all the databases. I checked the job history log
for the backup that appeared to have failed
error message, and the sqllog stated that the job completed.
(see log messages below)
I am beginning to think that there my be a problem with
the patch and the notification services.
I would appreciate any comments or suggestions.
Thank you,
Maris
SQLlog:
Message
Database backed up. Database: xxxxxx_fye, creation date(time): 2007/04/11(08:28:12), pages dumped: 787, first LSN: 80:179:37, last LSN: 80:195:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'T:\SQLBackups\xxxxxx_fye_backup_200811062200.bak'}). This is an informational message only. No user action is required.
jog history log:
Date11/6/2008 10:00:00 PM
LogJob History (mpDaily_General.Subplan)
Step ID1
Server[removed server name]
Job NamempDaily_General.Subplan
Step NameSubplan
Duration00:04:48
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: ABC\xxxxxxxxxx-SQLAdmin. ...042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:00:00 PM Progress: 2008-11-06 22:00:08.35 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [XX_FlashlinePoll] TO DISK = N'T:".: 100% complete End Progress Progress: 2008-11-06 22:01:37.98 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [XX_VCenter] TO DISK = N'T:\SQLBa".: 100% complete End Progress Progress: 2008-11-06 22:01:38.87 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [xxxxxx_MailServices] TO DISK".: 100% complete End Progress Progress: 2008-11-06 22:01:39.55 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [xxxxx_practice] TO DISK = N".: 100% complete End Progress Progress: 2008-11-06 22:01:40.88 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [xxxxxx_fye]... The package execution fa... The step failed.
November 7, 2008 at 8:40 am
Can you try dropping the existing plan and creating it again if noone(who has faced this before) replies back back with solution?
MJ
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply