August 19, 2010 at 10:26 pm
Following is the job error log:-
***************************************************
Date19/08/2010 10:02:52 PM
LogJob History (Update Standby Pro with Logs)
Step ID3
ServerABCSQDR01\DR04
Job NameUpdate Standby Pro with Logs
Step NameRestore Log to Standby Pro db
Duration00:16:22
Sql Severity16
Sql Message ID3013
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: AP\aussqladmin. ...on file 1. [SQLSTATE 01000] (Message 4035) Processed 35520 pages for database 'Pro', file 'Pro_Log' on file 1. [SQLSTATE 01000] (Message 4035) Processed 0 pages for database 'Pro', file 'sysft_ePro_Resumes_6Months' on file 1. [SQLSTATE 01000] (Message 4035) Processed 0 pages for database 'Pro', file 'sysft_ePro_Resumes_12Months' on file 1. [SQLSTATE 01000] (Message 4035) Processed 0 pages for database 'Pro', file 'sysft_ePro_Resumes_Archive' on file 1. [SQLSTATE 01000] (Message 4035) RESTORE LOG successfully processed 35520 pages in 36.131 seconds (8.053 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 0 pages for database 'Pro', file 'Pro_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 180 pages for database 'Pro', file 'Pro_Log' on file 1. [SQLSTATE 01000] (Message 4035) Processed 0 pages for database 'Pro', file 'sysft_ePro_Resumes_6Months' on file 1. [SQLSTATE 01000] (Message 4035) Processed 0 pages for database 'Pro', file ... The step failed.
***************************************************
There is log shipping enabled on this server(not real time).
Please advise!!
August 20, 2010 at 1:42 pm
Hi Aman,
Add an output file to the job step and it will give more clarity on the error message
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply