- 论坛徽章:
- 0
|
察看辅助数据库的相关job(LSRestore_Manit_sh-prod)的history,总是呈现下面的错误:
先是数十次的Skip:
---------------------------------------------------------------------------------------------------------
Date 4/7/2010 1:20:00 PM
Log Job History (LSRestore_sh-prod_MANIT)
Step ID 1
Server SH-SQLBKUP\SH_PROD_BACKUP
Job Name LSRestore_sh-prod_MANIT
Step Name Log shipping restore log job step.
Duration 00:00:25
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
2010-04-07 13:20:25.52 Skipped log backup file. Secondary DB: 'MANIT_Report', File: 'e:\manit_trans_log\MANIT_20100406014500.trn'
上面每次skip掉的trn文件都不同,就是尝试每一个trn文件,如果不能restore,就skip掉。
最后是Can not find a appropriate log file:
---------------------------------------------------------------------------------------------------------
Date 4/7/2010 1:20:00 PM
Log Job History (LSRestore_sh-prod_MANIT)
Step ID 1
Server SH-SQLBKUP\SH_PROD_BACKUP
Job Name LSRestore_sh-prod_MANIT
Step Name Log shipping restore log job step.
Duration 00:00:25
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
2010-04-07 13:20:25.61 Skipped log backup file. Secondary DB: 'MANIT_Report', File: 'e:\manit_trans_log\MANIT_20100406014000.trn'
2010-04-07 13:20:25.61 *** Error: Could not find a log backup file that could be applied to secondary database 'MANIT_Report'.(Microsoft.SqlServer.Management.LogShipping) ***
2010-04-07 13:20:25.61 Deleting old log backup files. Primary Database: 'MANIT'
2010-04-07 13:20:25.61 The restore operation completed with errors. Secondary ID: '09f6796f-f6f2-448d-b4af
lijianger
Sorry, 可能是我的表述使你产生了误解,我所说的skip是在每次restore时,都会发生的,因为在secondary 端的copy文件夹下有很多的trn文件,所以LSRestore job会找每一个trn, 如果不能restore就skip, 直到都找遍了,最后就报restore failed. 导出的LSRestore History如下:(需要从下往上看)
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Error,0,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,(Job outcome),,The job failed. The Job was invoked by Schedule 24 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).,00:00:26,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Error,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,Executed as user: SH-SQLBKUP\SYSTEM. The step failed.,00:00:26,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:25.80 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406014000.trn'<nl/>2010-04-07 13:00:25.80 *** Error: Could not find a log backup file that could be applied to secondary database 'MANIT_Report'.(Microsoft.SqlServer.Management.LogShipping) ***<nl/>2010-04-07 13:00:25.80 Deleting old log backup files. Primary Database: 'MANIT'<nl/>2010-04-07 13:00:25.81 The restore operation completed with errors. Secondary ID: '09f6796f-f6f2-448d-b4af-60fffb31586d'<nl/>2010-04-07 13:00:25.81 ----- END OF TRANSACTION LOG RESTORE -----<nl/><nl/>Exit Status: 1 (Error),00:00:25,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:25.71 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406014500.trn',00:00:25,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:25.60 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406015000.trn',00:00:25,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:25.50 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406015500.trn',00:00:25,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:25.42 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406020000.trn',00:00:25,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:25.31 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406020500.trn',00:00:25,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:25.13 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406021500.trn'<nl/>2010-04-07 13:00:25.22 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406021000.trn',00:00:25,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:25.03 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406022000.trn',00:00:25,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.94 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406022500.trn',00:00:25,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.83 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406023000.trn',00:00:24,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.74 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406023501.trn',00:00:24,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.64 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406024000.trn',00:00:24,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.55 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406024500.trn',00:00:24,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.36 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406025500.trn'<nl/>2010-04-07 13:00:24.46 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406025000.trn',00:00:24,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.27 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406030000.trn',00:00:24,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.17 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406030500.trn',00:00:24,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.08 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406031000.trn',00:00:24,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:24.00 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406031500.trn',00:00:24,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:23.91 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406032000.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:23.83 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406032500.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:23.72 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406033000.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:23.63 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406033500.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:23.53 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406034000.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:23.38 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406035000.trn'<nl/>2010-04-07 13:00:23.46 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406034500.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:23.28 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406035501.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:23.21 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406040000.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:23.03 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406041000.trn'<nl/>2010-04-07 13:00:23.11 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406040500.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:22.96 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406041500.trn',00:00:23,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:22.86 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406042000.trn',00:00:22,0,0,,,,0
04/07/2010 13:00:00,LSRestore_sh-prod_MANIT,Unknown,1,SH-SQLBKUP\SH_PROD_BACKUP,LSRestore_sh-prod_MANIT,Log shipping restore log job step.,,2010-04-07 13:00:22.77 Skipped log backup file. Secondary DB: 'MANIT_Report'<c/> File: 'e:\manit_trans_log\MANIT_20100406042500.trn',00:00:22,0,0,,,,0 |
|