May 12, 2010 at 11:23 pm
HI All,
The following mail notification received for recently.Job failes but when i check from that file path file copied for that time.
Please suggest on this failure notification.
JOB NAME :Differential Backup
REASON :Executed as user: SS\service. ...TAL_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 7 pages for database 'Capital', file 'CAPITAL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE WITH DIFFERENTIAL successfully processed 26527 pages in 17.515 seconds (12.406 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 504 pages for database 'ADMIN', file 'Admin_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 2 pages for database 'ADMIN', file 'Admin_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE WITH DIFFERENTIAL successfully processed 506 pages in 0.465 seconds (8.904 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 3152 pages for database 'Metrics', file 'Metrics' on file 1. [SQLSTATE 01000] (Message 4035) Processed 16488 pages for database 'Metrics', file 'Metrics1' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'Metrics', file 'Metrics_log' on file 1. [SQLSTATE ... The step failed.
TIME :20100512:2015
May 13, 2010 at 12:58 am
Your message doesnt show any thing bad here.
See the sql error log at the time when backup got failed . if you didnt get any thing there.again try to take backup. might be other backend process made its failure.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 1:08 am
hi bhuvnesh,
Please look into last line.
[SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'Metrics', file 'Metrics_log' on file 1. [SQLSTATE ... The step failed.
TIME :20100512:2015
I got failure notification , in job history also the same message appears.
thanks
udhay
May 13, 2010 at 1:28 am
are you doing this for log shipping ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 13, 2010 at 1:29 am
Did you get anything from Sql error log ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply