Re: Log Shipping Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 12:26:16 +0200

Sunil
How do you implement the log shipping?
Do you perform BACKUP LOG withinit OPTION and then RESTORE it.
It seems you have lost a consistency (brocken a chain) of the database.

drop database test
go
create database test
GO
Alter database set recovery full
create table test..test(id int identity)
insert test..test default values
backup database test to disk = 'd:\db.bak' WITH INIT
insert test..test default values
backup log test to disk = 'd:\log.bak'WITH INIT
insert test..test default values
backup log test to disk = 'd:\log.bak' WITH INIT
GO
RESTORE DATABASE test FROM disk = 'd:\db.bak' WITH FILE = 1, norecovery
RESTORE LOG test FROM disk = 'd:\log.bak' WITH recovery
GO

After running tthis script you supposed to get the same error.

"Sunil" <anonymous@discussions.microsoft.com> wrote in message
news:61F86E7E-5F98-4582-8740-AF5DE5F31000@microsoft.com...
> I've installed log shipping, it was working very fine but since last 2
days it is givving this type error as given below. Anyone plz help me it's
urgent and in this scenario what should I do
>
>
>
>
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4305: [Microsoft][ODBC
SQL Server Driver][SQL Server]The log in this backup set begins at LSN
589000000013600001, which is too late to apply to the database. An earlier
log backup that includes LSN 589000000011700001 can be restored.
> [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating
abnormally.
>
>
>
> Thanks in advance and Regards,
>
>
>
> Sunil

Relevant Pages

  • Logs/Restore Logs
    ... Whats contained the the Backup Log Files? ... the log takes place on say a standby server? ... the log after executing those statements, will the log contain those DML ... And if it does contain the DML, does that mean that when a restore log ...
    (microsoft.public.sqlserver.server)
  • Logging shadow copy activity?
    ... A customer called today and said that some of their files mysteriously ... I checked the backup log and no ... one has done a restore. ... I have shadow copy enabled on the volume and I wonder ...
    (microsoft.public.windows.server.sbs)
  • How do I catalog a Tape HELP!!
    ... I have a probelm and need to Restore some files ... The Tape is NOT shown in backup log ... Tools only allow Catalog from FILE NAME and NOT Tape!! ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Restore Error
    ... backup database test to disk = 'd:\db.bak' WITH INIT ... RESTORE statement to just overwrite the contents of the log. ...
    (microsoft.public.sqlserver.server)
  • Re: Backup log - will it truncate?
    ... BACKUP LOG <databasename> ... Hugo Kornelis, SQL Server MVP ...
    (comp.databases.ms-sqlserver)