Script Restore – Restaurando vários arquivos de Backup de Log – Plano de Manutenção

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.

  • 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:

Linha 189:

Linha 252:

Linha 353:

  • 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.

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.

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.

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.

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.

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.

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.

Fique feliz se você receber uma mensagem parecida informando zero erros!!! =)

Por fim, geramos o comando para que você possa excluir a base após finalizar os testes.


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:

Link: https://github.com/luizvitorf/SQLServer/blob/master/Scripts/Backup%20e%20Restore/Script%20Restore%20%E2%80%93%20Restaurando%20v%C3%A1rios%20arquivos%20de%20Backup%20de%20Log%20%E2%80%93%20Plano%20de%20Manuten%C3%A7%C3%A3o.sql


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

4 comentários em “Script Restore – Restaurando vários arquivos de Backup de Log – Plano de Manutenção

  1. Pingback: Script Restore – Restaurando vários arquivos de Backup de Log – Utilizando o MSDB – Luiz Lima

  2. Pingback: Script Restore – Restaurando vários arquivos de Backup de Log – Opções STOPAT e STANDBY – Luiz Lima

  3. sandro servino Responder

    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).

Deixe uma resposta