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

Sign In or Register to comment.