Differential Backup

I have a full and differential backups with script listed
below from SQL Server 2000 BOL. I was able to create the
full backup and the differential backups with the script
listed below without a problem. I trying to restore the
full and differential from SQL Server 2000 Enterprise
Manager GUI. First I restored the full back from the SQL
Server 2000 Enterprise Manager Restore GUI without a
problem.
Next I tried to restore the differential backup from the
SQL Server 2000 Enterprise Manager GUI using the restore
type as differential. I received the following error:
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. RESTORE DATABASE is terminating
abnormally.
Is it possible to restore a full/differential backup from
the SQL Server 2000 Enterprise Manager Restore GUI?
Please help me resolve this problem.
Thanks,
Jan
Hi,
Check the "Leave database nonoperational but able to restore additional
transaction logs." or "Leave database read-only and able to restore
additional transaction logs." radio button on the Options tab before start
the restore from full backup.
This operation create restore script with "WIH NORECOWERY" or "WITH STANDBY"
clause, and you can restore from differential backup as need.
Andras Jakus MCDBA
"anonymous@.discussions.microsoft.com" wrote:

> I have a full and differential backups with script listed
> below from SQL Server 2000 BOL. I was able to create the
> full backup and the differential backups with the script
> listed below without a problem. I trying to restore the
> full and differential from SQL Server 2000 Enterprise
> Manager GUI. First I restored the full back from the SQL
> Server 2000 Enterprise Manager Restore GUI without a
> problem.
> Next I tried to restore the differential backup from the
> SQL Server 2000 Enterprise Manager GUI using the restore
> type as differential. I received the following error:
> 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. RESTORE DATABASE is terminating
> abnormally.
> Is it possible to restore a full/differential backup from
> the SQL Server 2000 Enterprise Manager Restore GUI?
> Please help me resolve this problem.
> Thanks,
> Jan
>
>