Por isso que queria postar o resultado completo da consulta.
O tipo ta do jeito que falei:
1 - FULL, 2 - LOG, 3 - LOG, 4 - LOG, 5 - LOG, 6 - LOG
Dessa forma quando faço:
RESTORE DATABASE Banco
FROM DISK = 'C:\BACKUP\BACKUP\Banco.BAK'
WITH FILE = 1, NORECOVERY
RESTORE LOG Banco
FROM DISK = 'C:\BACKUP\BACKUP\Banco.BAK'
WITH FILE = 2, NORECOVERY
RESTORE Log Banco
FROM DISK = 'C:\BACKUP\BACKUP\Banco.BAK'
WITH FILE = 3, NORECOVERY
RESTORE Log Banco
FROM DISK = 'C:\BACKUP\BACKUP\Banco.BAK'
WITH FILE = 4, NORECOVERY
RESTORE Log Banco
FROM DISK = 'C:\BACKUP\BACKUP\Banco.BAK'
WITH FILE = 5, NORECOVERY
RESTORE Log Banco
FROM DISK = 'C:\BACKUP\BACKUP\Banco.BAK'
WITH FILE = 6, RECOVERY
Não está dando certo, ele restaura o FULL mas a partir do de LOG da erro, veja abaixo:
Processed 165512 pages for database 'Banco', file 'Banco_Data' on file 1.
Processed 2 pages for database 'Banco', file 'Banco_Log' on file 1.
RESTORE DATABASE successfully processed 165514 pages in 199.932 seconds (6.781 MB/sec).
Server: Msg 4305, Level 16, State 1, Line 5
The log in this backup set begins at LSN 46417000002036400001, which is too late to apply to the database. An earlier log backup that includes LSN 45976000004416700001 can be restored.
Server: Msg 3013, Level 16, State 1, Line 5
RESTORE LOG is terminating abnormally.
Server: Msg 4305, Level 16, State 1, Line 9
The log in this backup set begins at LSN 46417000003542500001, which is too late to apply to the database. An earlier log backup that includes LSN 45976000004416700001 can be restored.
Server: Msg 3013, Level 16, State 1, Line 9
RESTORE LOG is terminating abnormally.
Server: Msg 4305, Level 16, State 1, Line 13
The log in this backup set begins at LSN 46418000000838300001, which is too late to apply to the database. An earlier log backup that includes LSN 45976000004416700001 can be restored.
Server: Msg 3013, Level 16, State 1, Line 13
RESTORE LOG is terminating abnormally.
Server: Msg 4305, Level 16, State 1, Line 17
The log in this backup set begins at LSN 46418000003238400001, which is too late to apply to the database. An earlier log backup that includes LSN 45976000004416700001 can be restored.
Server: Msg 3013, Level 16, State 1, Line 17
RESTORE LOG is terminating abnormally.
Server: Msg 4305, Level 16, State 1, Line 21
The log in this backup set begins at LSN 46418000004017500001, which is too late to apply to the database. An earlier log backup that includes LSN 45976000004416700001 can be restored.
Server: Msg 3013, Level 16, State 1, Line 21
RESTORE LOG is terminating abnormally.
