Olá Pessoal,
No post de hoje vou compartilhar um script para fazer o RESTORE de uma database utilizando vários arquivos de Backup de Log. Utilizamos bastante esse script nas nossas Consultorias de Banco de Dados para atender algumas solicitações dos clientes ou para fazer um teste de restore e validar os backups.
Segue abaixo um exemplo de uma situação que é comum no dia a dia de um DBA:
Cliente – “Socorro Luiz!!! Acabei de executar um DELETE sem WHERE e excluí todos os dados da tabela de produção!!! Me ajuda por favor ou vou ser demitido!!!”
Luiz – Fica tranquilo, podemos restaurar os dados utilizando os backups de log até alguns instantes antes do DELETE. Nenhum dado será perdido!
Cliente – “Obrigado!!! Você salvou a minha vida!!! Você é o cara!!!”
Entendendo o script:
-
Parâmetros iniciais:
A ideia do script de Restore é você apenas alterar os parâmetros informando o nome da base e os arquivos de backup que serão utilizados.
IMPORTANTE: Ao executar, o resultado será um outro script que você deverá copiar em outra query para fazer o RESTORE.
A opção do STANDBY eu irei abordar em um próximo post. Ignore essa por enquanto OK.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
--------------------------------------------------------------------------------------------------------------------------------- -- Parametros para realizar o Backup -------------------------------------------------------------------------------------------------------------------------------- DECLARE @DatabaseDestino VARCHAR(8000), @Ds_Caminho_StandyBy VARCHAR(8000), @Ds_Pasta_Log VARCHAR(8000), @Nm_Arquivo_Log VARCHAR(8000), @Ds_Caminho_Backup_Full VARCHAR(8000), @Ds_Caminho_Backup_Diff VARCHAR(8000), @Ds_Extensao_Backup_Log VARCHAR(8000), @ComandoBackupFULL varchar(8000), @ComandoBackupDiferencial varchar(8000), @ComandoBackupLog varchar(8000), @DatabaseOrigem varchar(8000), @Ultimo_Backup_FULL datetime, @Ultimo_Backup_Diferencial datetime select @DatabaseOrigem = 'NomeDatabase', @DatabaseDestino = 'TesteRestore_NomeDatabase', @Ds_Caminho_Backup_Full = 'C:\SQLServer\Backup\NomeDatabase_Dados.bak', -- Caminho \ Nome do Backup Full. @Ds_Caminho_Backup_Diff = NULL, --'C:\SQLServer\Backup\NomeDatabase_Diff_Dados.bak', -- Caminho \ Nome do Backup Diferencial. Caso contrário, deve informar NULL. @Ds_Caminho_StandyBy = NULL, --'C:\SQLServer\Backup\NomeDatabase_StandBy', -- Informar o nome do Arquivo para o Standy By. Caso contrário, deve informar NULL. @Ds_Extensao_Backup_Log = '.trn', -- Extensão dos Arquivos de Log. Informar o prefixo ".". @Ds_Pasta_Log = 'C:\SQLServer\Backup\NomeDatabase\' -- Caminho da Pasta dos Arquivos de Log. Colocar a "\" no final. |
-
Observações:
- Versão SQL Server:
Dependendo da versão do SQL Server que você utilizar, pode ser necessário comentar algumas linhas desse script. Caso contrário, você pode receber o erro abaixo:
|
1 2 3 4 |
Msg 213, Level 16, State 7, Line 1 Column name or number of supplied values does not match table definition. Msg 3013, Level 16, State 1, Line 1 RESTORE HEADERONLY is terminating abnormally. |
Linha 189:
|
1 2 3 4 |
Containment tinyint, -- Include this column if using SQL 2012 KeyAlgorithm nvarchar(32), -- Include this column if using SQL 2014 EncryptorThumbprint varbinary(20), -- Include this column if using SQL 2014 EncryptorType nvarchar(32) -- Include this column if using SQL 2014 |
Linha 252:
|
1 2 3 4 |
Containment tinyint, -- Include this column if using SQL 2012 KeyAlgorithm nvarchar(32), -- Include this column if using SQL 2014 EncryptorThumbprint varbinary(20), -- Include this column if using SQL 2014 EncryptorType nvarchar(32) -- Include this column if using SQL 2014 |
Linha 353:
|
1 2 |
TDEThumbprint varbinary(32), -- Remove this column if using SQL 2005 SnapshotURL nvarchar(360) -- Include this column if using SQL 2016 |
- Plano de Manutenção:
Esse script foi preparado especificamente para restaurar Backups de Log que seguem um padrão de nome. Utilizamos como base os Backups gerados através do Plano de Manutenção do próprio SQL Server. Repare no exemplo abaixo que o padrão será o nome da database, “backup”, data, hora e a extensão “.trn”.
Exemplo – Padrão Nome Arquivo Backup de Log:
NOME_DATABASE_backup_2019_02_19_080418_0336431.trn
“Ah Luiz, mas porque seguir um padrão de nome se seria muito mais fácil apenas listar TODOS os arquivos da pasta???”
Optamos por seguir esse padrão por causa da PERFORMANCE, pois em alguns casos podemos ter milhares de arquivos de backup de log em uma pasta, com isso, ao tentar listar o cabeçalho de cada um dos arquivos para identificar o horário do backup, o script estava demorando alguns minutos. Com esse padrão que utilizamos, o script executa em poucos segundos, basta informar o caminho da pasta e a extensão do arquivo do Backup de Log.
É claro que existem diversas formas de listar e restaurar os arquivos, estou apenas exibindo mais uma opção para executar essa tarefa. Se você desejar também pode adaptar esse script a seu critério. Fique a vontade.
Resultado do script:
Nesse script utilizo a procedure “xp_cmdshell” para listar os arquivos da pasta de Backup de Log. Com isso, fiz um tratamento para habilitar e desabilitar essa opção para manter a configuração do seu servidor após a execução do script. Nesse caso, serão exibidas algumas mensagens no início do Resultado e elas devem ser desconsideradas. Se a opção já estiver habilitada, o script irá executar normalmente sem exibir essas mensagens.
|
1 2 3 4 5 6 7 8 9 |
Desconsiderar essa mensagem: Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. Desconsiderar essa mensagem: Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE statement to install. Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. Desconsiderar essa mensagem: Configuration option 'xp_cmdshell' changed from 1 to 0. Run the RECONFIGURE statement to install. Desconsiderar essa mensagem: Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. |
O primeiro passo para restaurar a nossa base será executar um RESTORE com o BACKUP FULL. Nesse momento, a base será criada no SQL Server com o status “RESTORING” e os arquivos de dados e log também serão criados nos caminhos informados na clausula MOVE. Lembrando que a base não estará disponível para acesso enquanto estiver com o status “RESTORING”. Iremos deixar ela acessível apenas após restaurar os Backups de Log.
Repare também que todos os scripts de RESTORE possuem o horário que o Backup foi executado e isso nos ajuda bastante a entender a ordem cronológica e a relação entre cada Backup.
|
1 2 3 4 5 6 7 |
-- FULL -- 2019-02-19 07:52:32 RESTORE DATABASE TesteRestore_BASE_PRODUCAO FROM DISK = 'C:\SQLServer\Backup\BASE_PRODUCAO_Full.bak' WITH NORECOVERY , STATS = 1, MOVE 'BASE_PRODUCAO_2' TO 'C:\SQLServer\Data\BASE_PRODUCAO_2_TesteRestore_BASE_PRODUCAO.ndf', MOVE 'BASE_PRODUCAO_log' TO 'C:\SQLServer\Log\BASE_PRODUCAO_log_TesteRestore_BASE_PRODUCAO.ldf', MOVE 'BASE_PRODUCAO' TO 'C:\SQLServer\Data\BASE_PRODUCAO_TesteRestore_BASE_PRODUCAO.mdf' |
Esse comando será gerado apenas se você utilizar o parâmetro do Backup Diferencial. Ele irá restaurar as alterações desde o último Backup Full que você restaurou no passo anterior.
|
1 2 3 4 |
-- DIFERENCIAL -- 2019-02-19 07:58:29 RESTORE DATABASE TesteRestore_BASE_PRODUCAO FROM DISK = 'C:\SQLServer\Backup\BASE_PRODUCAO_Diferencial.bak' WITH NORECOVERY, STATS = 1 |
Aqui será gerado o script de restore para cada arquivo de Backup de Log que fizer parte da cadeia de Backup que estamos restaurando. Digo isso porque o script tem uma Inteligência pra ignorar os outros arquivos. Repare que na pasta tinha 10 arquivos, mas apenas 5 serão utilizados no nosso restore, pois os outros 5 foram gerados antes do Backup Full e não serão necessários para o nosso teste.
Uma observação é que aqui podemos restaurar os logs até o horário desejado. Por exemplo, se o cliente pedir para restaurar os dados apenas até as 08:19 horas, bastaria ignorar os dois últimos arquivos do resultado e depois deixar a base ONLINE. Além disso, também poderíamos utilizar um horário ainda mais específico com a opção STOPAT, por exemplo às 08:10 horas e 25 segundos, mas esse assunto ficará para um próximo post.
|
1 2 3 4 5 6 |
-- LOG RESTORE LOG TesteRestore_BASE_PRODUCAO from disk = 'C:\SQLServer\Backup\Log\BASE_PRODUCAO\BASE_PRODUCAO_backup_2019_02_19_080418_0336431.trn' WITH FILE = 1, NORECOVERY -- 2019-02-19 08:04:00 RESTORE LOG TesteRestore_BASE_PRODUCAO from disk = 'C:\SQLServer\Backup\Log\BASE_PRODUCAO\BASE_PRODUCAO_backup_2019_02_19_081636_7437466.trn' WITH FILE = 1, NORECOVERY -- 2019-02-19 08:16:00 RESTORE LOG TesteRestore_BASE_PRODUCAO from disk = 'C:\SQLServer\Backup\Log\BASE_PRODUCAO\BASE_PRODUCAO_backup_2019_02_19_081930_2194778.trn' WITH FILE = 1, NORECOVERY -- 2019-02-19 08:19:00 RESTORE LOG TesteRestore_BASE_PRODUCAO from disk = 'C:\SQLServer\Backup\Log\BASE_PRODUCAO\BASE_PRODUCAO_backup_2019_02_19_082210_0661797.trn' WITH FILE = 1, NORECOVERY -- 2019-02-19 08:22:00 RESTORE LOG TesteRestore_BASE_PRODUCAO from disk = 'C:\SQLServer\Backup\Log\BASE_PRODUCAO\BASE_PRODUCAO_backup_2019_02_19_082626_8088682.trn' WITH FILE = 1, NORECOVERY -- 2019-02-19 08:26:00 |
Nesse ponto iremos alterar o status da base de “RESTORING” para “ONLINE”. A partir de agora a base já estará disponível para ser acessada.
|
1 2 |
-- Comando para deixar a base ONLINE RESTORE DATABASE TesteRestore_BASE_PRODUCAO WITH RECOVERY |
Após restaurar uma base de teste, lembre de alterar também o Recovery Model para SIMPLE para evitar que o arquivo de log fique crescendo e não precisar fazer o Backup de Log.
|
1 2 |
-- Comando para alterar o recovery model da base restaurada ALTER DATABASE TesteRestore_BASE_PRODUCAO SET RECOVERY SIMPLE |
Esse passo é OPCIONAL, como a ideia do script é validar se os backups estão OK, nós também aproveitamos para validar se a base não possui nenhuma Corrupção de Dados, pois mesmo que os backups sejam executados com sucesso, a base pode estar corrompida e isso não é bom. Se for esse o caso, você poderá executar as ações necessárias para tentar corrigir o problema mais rapidamente.
|
1 2 |
-- Comando para validar se a base está OK DBCC CHECKDB('TesteRestore_BASE_PRODUCAO') |
Fique feliz se você receber uma mensagem parecida informando zero erros!!! =)
|
1 2 |
CHECKDB found 0 allocation errors and 0 consistency errors in database 'TesteRestore_BASE_PRODUCAO'. DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
Por fim, geramos o comando para que você possa excluir a base após finalizar os testes.
|
1 2 |
-- Comando para excluir a base de teste -- DROP DATABASE TesteRestore_BASE_PRODUCAO |
Pronto! Conseguimos validar com sucesso os nossos Backups e além disso executar um CHECKDB para validar que não existe corrupção de dados. Como eu informei no início do post, esse script é muito útil em nossas consultorias e pode ser utilizado para fazer o Teste de Restore nos clientes pelo menos uma vez por mês. Espero que tenha conseguido explicar como ele funciona e se tiver alguma dúvida deixe um comentário para que eu possa tentar te ajudar.
E você, já está validando os Backups do seu ambiente? Está esperando o que?
Nos próximos posts irei mostrar um outro script para fazer o restore utilizando o MSDB e depois também irei falar sobre as opções STOPAT e STANDBY com mais detalhes. Aguarde!!!
Veja também:
https://luizlima.net/solicitacao-restore-script-envio-email/
Download “Script Restore – Restaurando vários arquivos de Backup de Log – Plano de Manutenção”:
Segue o link para baixar o script utilizado nesse Post:
Espero que tenha gostado e que isso também possa ser útil no seu dia a dia. Até o próximo post!
Me siga no LinkedIn e YouTube para ficar por dentro das novidades.
Abraço,
Luiz Vitor França Lima
Consultor SQL Server
Pingback: Script Restore – Restaurando vários arquivos de Backup de Log – Utilizando o MSDB – Luiz Lima
Pingback: Script Restore – Restaurando vários arquivos de Backup de Log – Opções STOPAT e STANDBY – Luiz Lima
Olha, muito bom o script, parabéns. Recebi um erro no teste de restore dos logs, segue o resultado:
RESTORE DATABASE successfully processed 43127318 pages in 2967.689 seconds (113.533 MB/sec).
Msg 4326, Level 16, State 1, Line 17
The log in this backup set terminates at LSN 127358001410446400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 17
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 18
The log in this backup set terminates at LSN 127358001885953600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 18
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 19
The log in this backup set terminates at LSN 127359000503087200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 19
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 20
The log in this backup set terminates at LSN 127359000467931200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 20
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 21
The log in this backup set terminates at LSN 127359000566556800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 21
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 22
The log in this backup set terminates at LSN 127359000291784800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 22
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 23
The log in this backup set terminates at LSN 127358001395141600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 23
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 24
The log in this backup set terminates at LSN 127360000181863200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 24
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 25
The log in this backup set terminates at LSN 127359000107322400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 25
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 26
The log in this backup set terminates at LSN 127358001727888800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 26
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 27
The log in this backup set terminates at LSN 127360000589883200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 27
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 28
The log in this backup set terminates at LSN 127358001452908000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 28
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 29
The log in this backup set terminates at LSN 127363000030106400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 29
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 30
The log in this backup set terminates at LSN 127362000524319200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 30
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 31
The log in this backup set terminates at LSN 127364000450124000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 31
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 32
The log in this backup set terminates at LSN 127364000185841600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 32
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 33
The log in this backup set terminates at LSN 127362000083169600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 33
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 34
The log in this backup set terminates at LSN 127363000311584800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 34
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 35
The log in this backup set terminates at LSN 127363000791767200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 35
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 36
The log in this backup set terminates at LSN 127364000329724800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 36
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 37
The log in this backup set terminates at LSN 127363000709516800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 37
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 38
The log in this backup set terminates at LSN 127364000074208000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 38
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 39
The log in this backup set terminates at LSN 127364000794427200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 39
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 40
The log in this backup set terminates at LSN 127363000467737600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 40
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 41
The log in this backup set terminates at LSN 127366000213320000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 41
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 42
The log in this backup set terminates at LSN 127366000619099200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 42
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 43
The log in this backup set terminates at LSN 127365000707860000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 43
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 44
The log in this backup set terminates at LSN 127365000221293600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 44
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 45
The log in this backup set terminates at LSN 127366000344897600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 45
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 46
The log in this backup set terminates at LSN 127367000202536000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 46
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 47
The log in this backup set terminates at LSN 127371000079221600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 47
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 48
The log in this backup set terminates at LSN 127373000180542400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 48
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 49
The log in this backup set terminates at LSN 127431000701668800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 49
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 50
The log in this backup set terminates at LSN 127439000124367200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 50
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 51
The log in this backup set terminates at LSN 127439000224640000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 51
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 52
The log in this backup set terminates at LSN 127437000048898400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 52
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 53
The log in this backup set terminates at LSN 127439000011408800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 53
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 54
The log in this backup set terminates at LSN 127438000516068000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 54
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 55
The log in this backup set terminates at LSN 127436000720088000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 55
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 56
The log in this backup set terminates at LSN 127440000436856000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 56
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 57
The log in this backup set terminates at LSN 127440000498973600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 57
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 58
The log in this backup set terminates at LSN 127439000423103200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 58
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 59
The log in this backup set terminates at LSN 127439000708564000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 59
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 60
The log in this backup set terminates at LSN 127440000712108000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 60
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 61
The log in this backup set terminates at LSN 127439000311132000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 61
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 62
The log in this backup set terminates at LSN 127439000536636000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 62
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 63
The log in this backup set terminates at LSN 127439000382316000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 63
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 64
The log in this backup set terminates at LSN 127440000198477600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 64
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 65
The log in this backup set terminates at LSN 127439000489194400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 65
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 66
The log in this backup set terminates at LSN 127440000466052000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 66
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 67
The log in this backup set terminates at LSN 127439000519169600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 67
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 68
The log in this backup set terminates at LSN 127440000182470400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 68
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 69
The log in this backup set terminates at LSN 127441000039196000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 69
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 70
The log in this backup set terminates at LSN 127440000537184000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 70
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 71
The log in this backup set terminates at LSN 127440000213924000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 71
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 72
The log in this backup set terminates at LSN 127439000450905600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 72
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 73
The log in this backup set terminates at LSN 127442000677556800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 73
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 74
The log in this backup set terminates at LSN 127442000159801600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 74
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 75
The log in this backup set terminates at LSN 127442000539628000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 75
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 76
The log in this backup set terminates at LSN 127442000022396000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 76
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 77
The log in this backup set terminates at LSN 127443000339159200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 77
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 78
The log in this backup set terminates at LSN 127442000316183200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 78
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 79
The log in this backup set terminates at LSN 127441000518991200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 79
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 80
The log in this backup set terminates at LSN 127442000381308800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 80
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 81
The log in this backup set terminates at LSN 127443000087941600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 81
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 82
The log in this backup set terminates at LSN 127441000272042400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 82
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 83
The log in this backup set terminates at LSN 127442000802478400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 83
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 84
The log in this backup set terminates at LSN 127441000409667200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 84
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 85
The log in this backup set terminates at LSN 127442000460212000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 85
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 86
The log in this backup set terminates at LSN 127445000098956800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 86
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 87
The log in this backup set terminates at LSN 127445000516709600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 87
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 88
The log in this backup set terminates at LSN 127445000594540000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 88
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 89
The log in this backup set terminates at LSN 127445000690652000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 89
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 90
The log in this backup set terminates at LSN 127447000143382400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 90
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 91
The log in this backup set terminates at LSN 127445000374563200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 91
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 92
The log in this backup set terminates at LSN 127443000767976000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 92
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 93
The log in this backup set terminates at LSN 127444000376320000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 93
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 94
The log in this backup set terminates at LSN 127444000679370400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 94
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 95
The log in this backup set terminates at LSN 127446000747659200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 95
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 96
The log in this backup set terminates at LSN 127445000287853600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 96
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 97
The log in this backup set terminates at LSN 127446000282735200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 97
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 98
The log in this backup set terminates at LSN 127446000442919200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 98
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 99
The log in this backup set terminates at LSN 127445000646856000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 99
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 100
The log in this backup set terminates at LSN 127444000279954400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 100
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 101
The log in this backup set terminates at LSN 127446000488651200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 101
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 102
The log in this backup set terminates at LSN 127447000385828800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 102
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 103
The log in this backup set terminates at LSN 127447000360329600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 103
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 104
The log in this backup set terminates at LSN 127447000427296000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 104
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 105
The log in this backup set terminates at LSN 127448000565155200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 105
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 106
The log in this backup set terminates at LSN 127447000507861600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 106
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 107
The log in this backup set terminates at LSN 127447000474151200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 107
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 108
The log in this backup set terminates at LSN 127447000586297600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 108
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 109
The log in this backup set terminates at LSN 127447000601922400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 109
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 110
The log in this backup set terminates at LSN 127449000602946400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 110
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 111
The log in this backup set terminates at LSN 127450000347124000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 111
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 112
The log in this backup set terminates at LSN 127448000619479200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 112
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 113
The log in this backup set terminates at LSN 127448000586508800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 113
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 114
The log in this backup set terminates at LSN 127450000710396800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 114
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 115
The log in this backup set terminates at LSN 127450000220668800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 115
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 116
The log in this backup set terminates at LSN 127449000649417600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 116
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 117
The log in this backup set terminates at LSN 127447000565432000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 117
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 118
The log in this backup set terminates at LSN 127447000536999200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 118
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 119
The log in this backup set terminates at LSN 127449000737104000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 119
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 120
The log in this backup set terminates at LSN 127449000286156800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 120
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 121
The log in this backup set terminates at LSN 127450000612606400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 121
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 122
The log in this backup set terminates at LSN 127447000789371200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 122
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 123
The log in this backup set terminates at LSN 127451000211696800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 123
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 124
The log in this backup set terminates at LSN 127452000109772000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 124
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 125
The log in this backup set terminates at LSN 127451000777644000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 125
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 126
The log in this backup set terminates at LSN 127452000525744800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 126
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 127
The log in this backup set terminates at LSN 127451000333435200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 127
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 128
The log in this backup set terminates at LSN 127453000280600800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 128
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 129
The log in this backup set terminates at LSN 127454000359057600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 129
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 130
The log in this backup set terminates at LSN 127454000398364800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 130
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 131
The log in this backup set terminates at LSN 127453000000540000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 131
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 132
The log in this backup set terminates at LSN 127451000663298400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 132
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 133
The log in this backup set terminates at LSN 127454000067492000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 133
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 134
The log in this backup set terminates at LSN 127451000714797600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 134
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 135
The log in this backup set terminates at LSN 127451000601105600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 135
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 136
The log in this backup set terminates at LSN 127452000279711200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 136
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 137
The log in this backup set terminates at LSN 127451000011904000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 137
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 138
The log in this backup set terminates at LSN 127454000311758400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 138
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 139
The log in this backup set terminates at LSN 127453000772821600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 139
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 140
The log in this backup set terminates at LSN 127457000330966400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 140
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 141
The log in this backup set terminates at LSN 127454000507400800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 141
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 142
The log in this backup set terminates at LSN 127455000755090400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 142
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 143
The log in this backup set terminates at LSN 127455000110849600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 143
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 144
The log in this backup set terminates at LSN 127454000548472800001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 144
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 145
The log in this backup set terminates at LSN 127456000182310400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 145
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 146
The log in this backup set terminates at LSN 127454000428121600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 146
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 147
The log in this backup set terminates at LSN 127457000519353600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 147
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 148
The log in this backup set terminates at LSN 127457000483444000001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 148
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 149
The log in this backup set terminates at LSN 127454000597049600001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 149
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 150
The log in this backup set terminates at LSN 127454000469474400001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 150
RESTORE LOG is terminating abnormally.
Msg 4326, Level 16, State 1, Line 151
The log in this backup set terminates at LSN 127454000663975200001, which is too early to apply to the database. A more recent log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 151
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 152
The log in this backup set begins at LSN 127458000008548000001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 152
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 153
The log in this backup set begins at LSN 127458000703896800001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000560181600001 can be restored.
Msg 3013, Level 16, State 1, Line 153
RESTORE LOG is terminating abnormally.
Processed 0 pages for database ‘bancox’, file ‘bancox’ on file 1.
Processed 27379 pages for database ‘bancox’, file ‘bancox_log’ on file 1.
RESTORE LOG successfully processed 27379 pages in 0.716 seconds (298.740 MB/sec).
Msg 4305, Level 16, State 1, Line 155
The log in this backup set begins at LSN 127457000714922400001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000563160000001 can be restored.
Msg 3013, Level 16, State 1, Line 155
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 156
The log in this backup set begins at LSN 127459000220692000001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000563160000001 can be restored.
Msg 3013, Level 16, State 1, Line 156
RESTORE LOG is terminating abnormally.
Processed 0 pages for database ‘bancox’, file ‘bancox’ on file 1.
Processed 40671 pages for database ‘bancox’, file ‘bancox_log’ on file 1.
RESTORE LOG successfully processed 40671 pages in 1.234 seconds (257.489 MB/sec).
Msg 4305, Level 16, State 1, Line 158
The log in this backup set begins at LSN 127457000680607200001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000628233600001 can be restored.
Msg 3013, Level 16, State 1, Line 158
RESTORE LOG is terminating abnormally.
Processed 0 pages for database ‘bancox’, file ‘bancox’ on file 1.
Processed 32734 pages for database ‘bancox’, file ‘bancox_log’ on file 1.
RESTORE LOG successfully processed 32734 pages in 0.891 seconds (287.015 MB/sec).
Msg 4305, Level 16, State 1, Line 160
The log in this backup set begins at LSN 127458000678746400001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 160
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 161
The log in this backup set begins at LSN 127457000740757600001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 161
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 162
The log in this backup set begins at LSN 127457000766250400001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 162
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 163
The log in this backup set begins at LSN 127458000722526400001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 163
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 164
The log in this backup set begins at LSN 127459000473294400001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 164
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 165
The log in this backup set begins at LSN 127459000633059200001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 165
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 166
The log in this backup set begins at LSN 127458000188604800001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 166
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 167
The log in this backup set begins at LSN 127461000414599200001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 167
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 168
The log in this backup set begins at LSN 127461000818580800001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 168
RESTORE LOG is terminating abnormally.
Msg 4305, Level 16, State 1, Line 169
The log in this backup set begins at LSN 127459000722414400001, which is too recent to apply to the database. An earlier log backup that includes LSN 127457000680607200001 can be restored.
Msg 3013, Level 16, State 1, Line 169
RESTORE LOG is terminating abnormally.
RESTORE DATABASE successfully processed 0 pages in 3.200 seconds (0.000 MB/sec).
Obrigado Sandro! Parece que tem algum backup fora da ordem ai. Faz um teste com alguma outra base ou então usa o script abaixo pra tentar encontrar o problema na sequência dos arquivos blz.
https://github.com/luizvitorf/SQLServer/blob/master/Scripts/Backup%20e%20Restore/Hist%C3%B3rico%20de%20Backup.sql
Abraço,
Luiz Vitor