SQL Error: The log in this backup, which is too recent to apply to the database

When performing a point in time restore of a SQL database, the restore may fail with the following error:

Error message:

Msg 4305, Level 16, State 1, Line 9
The log in this backup set begins at LSN 90000000031400001, which is too recent to apply to the database. An earlier log backup that includes LSN 90000000030600001 can be restored.
Msg 3013, Level 16, State 1, Line 9
RESTORE LOG is terminating abnormally.

Solution:

I tried to restore the transaction log, in time which was too recent to restore. What I mean is that stopat time was after taking the transaction log backup.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s