Re: ACO3505E during restore of SQL Server Transaction Logs

Neil,

It sounds as if you may have been bitten by the new
way that SQL 7.0 transaction logging works...

The following is from Microsoft:

| - In 7.0 backup, A database backup records the complete state of the data in
| the database at the time the backup operation completes.  Transaction log
| backup records the state of the transaction log at the time backup operation
| starts.
| An Example: backup that starts at 7:00 and ends at 7:10 will have data up to
| 7:10.
|
| In 6.5 , backup that starts at 7:00 and ends at 7:10 will have data up to
| 7:00 but transaction log backup will be updated till 7:10.
|
| Basically at sql server 6.5, any data changes made after the dump begins are
| not reflected in the dumped database, vice versa with SQL Server 7.0


Did you happen to do a "/TRUNCAFTER" (truncate after)
on your full backup?

If so, you would have deleted part of the transaction log
that the recovery is asking for.

For even more details, take a look at the Microsoft
Books Online (SQL 7.0) under "Virtual log Files".

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM ADSM Agent Development
hoobler AT us.ibm DOT com


>
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