I am trying to perform a point-in-time restore of a SQL Server database to
another SQL Server. This involves restoring the previous evening's full
database backup, and two incremental (transaction log) backups taken during
the day.

The full database restore completes successfully, but when I try to restore
the first transaction log backup, I receive the following error message:

    ACO3505E -- Failed write to SQL server. Check SQL server error log.


    Processing end of ADSM data. Please wait...

    SQL Status: DB-LIB message: This backup set cannot be restored because
the datab
    ase has not been rolled forward far enough. You must first restore all
earlier l
    ogs before restoring this log.

The command I used to restore the full backup is:

SQLDSMC /adsmnode:sapdev_sql /adsmpwd:****** /sqluser:sa /sqlpwd:******
/RESTOREFULL:DEV,09101999220925.db,SAPDEV /RECOVERY:NO

The command which fails to restore the first incremental backup is:

SQLDSMC /adsmnode:sapdev_sql /adsmpwd:****** /sqluser:sa /sqlpwd:******
/RESTOREINCR:DEV,09111999110120.log,SAPDEV /RECOVERY:NO

The incremental backup which I am trying to restore is the first backup
taken after the full backup. There is no information recorded in the SQL
server error log after the full backup is restored.

Does anybody know what I'm doing wrong?

Neil Schofield


The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject
to the legal notice available at http://www.keldagroup.com/email.htm
Kelda Group plc and its subsidiaries, UK
Registered in England and Wales No 2366627