Boa Tarde Pessoal,
Estou enfrentando vários problemas com a etapa de restore do Log shipping, se você olhar nos logs do SQL Server Agent ele apresenta com sucesso, mas na verdade ele não restaurou nada, ele simplesmente pulou todos os arquivos.
Log Do Sql Server Agent
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
09/05/2011 14:10:00,LSRestore_ServidorOrigem_Banco,Unknown,0,ServidorDestino,LSRestore_ServidorOrigem_Banco,(Job outcome),,The job succeeded. The Job was invoked by Schedule 42 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).,00:00:11,0,0,,,,0
09/05/2011 14:10:00,LSRestore_ServidorOrigem_Banco,Unknown,1,ServidorDestino,LSRestore_ServidorOrigem_Banco,Log shipping restore log job step.,,Executed as user: DOMINIO\Administrador. The step succeeded.,00:00:11,0,0,,,,0
09/05/2011 14:10:00,LSRestore_ServidorOrigem_Banco,Unknown,1,ServidorDestino,LSRestore_ServidorOrigem_Banco,Log shipping restore log job step.,,2011-09-05 14:10:10.81 ----- END OF TRANSACTION LOG RESTORE -----<nl/><nl/>Exit Status: 0 (Success),00:00:10,0,0,,,,0
09/05/2011 14:10:00,LSRestore_ServidorOrigem_Banco,Unknown,1,ServidorDestino,LSRestore_ServidorOrigem_Banco,Log shipping restore log job step.,,2011-09-05 14:10:10.77 The restore operation was successful. Secondary ID: '012e29ca-c437-44bc-a8d4-f218edab3f4c',00:00:10,0,0,,,,0
09/05/2011 14:10:00,LSRestore_ServidorOrigem_Banco,Unknown,1,ServidorDestino,LSRestore_ServidorOrigem_Banco,Log shipping restore log job step.,,2011-09-05 14:10:10.63 Could not find a log backup file that could be applied to secondary database 'Banco'.<nl/>2011-09-05 14:10:10.64 The restore operation was successful. Secondary Database: 'Banco'<c/> Number of log backup files restored: 0<nl/>2011-09-05 14:10:10.66 Deleting old log backup files. Primary Database: 'Banco',00:00:10,0,0,,,,0
09/05/2011 14:10:00,LSRestore_ServidorOrigem_Banco,Unknown,1,ServidorDestino,LSRestore_ServidorOrigem_Banco,Log shipping restore log job step.,,2011-09-05 14:10:10.58 Skipped log backup file. Secondary DB: 'Banco'<c/> File: '\\ServidorDestino\e$\LogShipping\Banco\Banco_20110905163001.trn'<nl/>2011-09-05 14:10:10.61 Skipped log backup file. Secondary DB: 'Banco'<c/> File: '\\ServidorDestino\e$\LogShipping\Banco\Banco_20110905164501.trn',00:00:10,0,0,,,,0
09/05/2011 14:10:00,LSRestore_ServidorOrigem_Banco,Unknown,1,ServidorDestino,LSRestore_ServidorOrigem_Banco,Log shipping restore log job step.,,2011-09-05 14:10:10.44 Skipped log backup file. Secondary DB: 'Banco'<c/> File: '\\ServidorDestino\e$\LogShipping\Banco\Banco_20110905154425.trn'<nl/>2011-09-05 14:10:10.48 Skipped log backup file. Secondary DB: 'Banco'<c/> File: '\\ServidorDestino\e$\LogShipping\Banco\Banco_20110905154501.trn'<nl/>2011-09-05 14:10:10.52 Skipped log backup file. Secondary DB: 'Banco'<c/> File: '\\ServidorDestino\e$\LogShipping\Banco\Banco_20110905160001.trn'<nl/>2011-09-05 14:10:10.55 Skipped log backup file. Secondary DB: 'Banco'<c/> File: '\\ServidorDestino\e$\LogShipping\Banco\Banco_20110905161501.trn',00:00:10,0,0,,,,0
Log Do Windows
Tipo de evento: Erro
Fonte de evento: MSSQLSERVER
Categoria do evento: (2)
Id. do evento: 14421
Data: 05/09/2011
Hora: 12:46:00
Usuário: DOMINIO\Administrador
Computador: ServidorDestino
Descrição:
The log shipping secondary database ServidorDestino.Banco has restore threshold of 45 minutes and is out of sync. No restore was performed for 2335 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information.
Para obter mais informações, visite o Centro de ajuda e suporte em http://go.microsoft.com/fwlink/events.asp.
Agradeço qualquer ajuda
Dionizio A Ferreira - MCP (70-270 / 70-290) Blog : http://my.opera.com/dionizioaf/blog/
