3159

Product

Name

Event ID

3159

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

LDDB_LOGNOTBACKEDUP

Message

Text

The tail of the log for the database “%ls” has not been backed up. Use BACKUP LOG WITH

NORECOVERY to back up the log if it contains work that you do not want to lose. Use the

WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the

contents of the log.

In most cases, under the full or bulk-logged recovery models, SQL Server requires that you

back up the tail of the log to capture the log records that have not yet been backed up. A log

backup taken of the tail of the log just before a restore operation is called a tail-log backup.

When you are recovering a database to the point of a failure, the tail-log backup is the last

backup of interest in the recovery plan. If you cannot back up the tail of the log, you can

recover a database only to the end of the last backup that was created before the failure.

usually requires that you take a tail-log backup before you start to restore a

database. The tail-log backup prevents work loss and keeps the log chain intact. However, not

all restore scenarios require a tail-log backup. You do not have to have a tail-log backup if the

recovery point is included in an earlier log backup, or if you are moving or replacing

(overwriting) the database and do not need to restore it to a point of time after the most

ﾉ

Expand table