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]
91;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 ea
rlier log backup that includes LSN 58900000
0011700001 can be restored.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is te
rminating abnormally.
Thanks in advance and Regards,
SunilSunil
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][ODB
C
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 terminat
ing
abnormally.
>
> Thanks in advance and Regards,
>
> Sunil
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment