What are the challenges you face when working across database platforms? Take the survey
Options

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

audunaudun Posts: 17
edited February 11, 2007 8:21PM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.