How can we help you today? How can we help you today?

Differential Backup created without full backup

I have created a new database using the full backup of another database.

For the new database I try to create a Differential Backup(Note: - no full backup has been made on the new database). The operation completes successfully. I.e. differential backup made without fullback.

Now trying to restore from differential backup causes the following error : -

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.
sangha
0

Comments

2 comments

Sort by
  • priyasinha
    Hi,

    Thanks for sparing your time to look at the beta and report this.

    We will include this validation in the final version of the SQL Backup.

    Regards.
    priyasinha
    0
  • petey
    The differential backup restriction is controlled by SQL Server, not by SQL Backup. In this case, the 'full backup' that's recognised by SQL Server is the one you used to perform the restore, hence the differential backup is allowed.

    To use the differential backup, you first need to restore the full backup with the NORECOVERY or STANDBY option. The differential backup can then be restored.

    Admittedly, the error message that SQL 2005 displays
    The log or differential backup cannot be restored because no files are ready to rollforward.
    is a little vague, compared to the error message that SQL 2000 displays in the same scenario
    The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
    petey
    0

Add comment

Please sign in to leave a comment.