The log or differential backup cannot be restored ....

audun

Hi

I am having an issue with SQLBackup ver 4.6.0.815 on a SQL Server 2005 (9.00.2047.00) system running on Windows 2003 SP1.

I am having problems restoring a diff backup upon a full backup (with NOrecovery).

Here are the statements I run:

Full:
exec master..sqlbackup '-SQL "RESTORE DATABASE restore_survey
FROM DISK = [\\192.168.1.16\g$\backup\sql\confirm_dbserver2\compressed_full_backup\survey_full_20070204_220414.zbak]
WITH
password=[xxxxxxx],
NORECOVERY,
replace,
MOVE [survey_dat] TO [s:\confirmit_sql_data\restore_survey.mdf],
MOVE [survey_log] TO [m:\confirmit_sql_log\restore_survey.ldf]
"'

This runs fine and running:
select name, crdate from sysdatabases where status & 32 = 32

confirms this by returning the database just restored.

Diff:
exec master..sqlbackup '-SQL "RESTORE DATABASE restore_survey
FROM DISK = [\\192.168.1.16\g$\backup\sql\confirm_dbserver2\compressed_diff_backup\survey_diff_20070208_220916.zbak]
WITH
password=[xxxxxxx],
RECOVERY "'

This returns:

Server: Msg 3013
RESTORE DATABASE is terminating abnormally.
Server: Msg 3117
The log or differential backup cannot be restored because no files are ready to rollforward.

Running the above query to check if the database has the same "..in the middle of a restore.." status does NOT return any rows.

The funny thing is that running the same restore using the GUI does not fail.

This has worked flawless earlier and I don't see what could have caused this "misbehaviour".

I have tried running with different users (sql auth / windows), restarting the sqlbackup service, trying on different databases etc without luck.

I would be grateful if anyone could "shed some light" on this.

Regards,
audun jensen

petey

Are there any other files in the \\192.168.1.16\g$\backup\sql\confirm_dbserver2\compressed_diff_backup folder that would match the file name pattern survey_diff_20070208_220916.zbak e.g. survey_diff_20070208_220916.zbak.old?

audun

No

petey

Could you pls try copying the differential backup file to another folder that contains nothing else, and try restoring from that folder instead? Do you receive the same error? Thanks.