|
Home > Archive > microsoft.public.cert.mcdba > April 2004 > Restoring differential backup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Restoring differential backup
|
|
| Amit Kumar 2004-04-07, 11:24 am |
| Dear support,
Please help me with this problem.
I am trying to restore the differential database backup
on SQL 2000 server. When i restore, it throws following
error
"Error 4306
Severity Level 16
Message Text
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."
I searched the standard solution for this error which
states as follows:-
"To recover a database, start the sequence over and use
the NORECOVERY clause on all RESTORE statements except
the last. If you are maintaining a standby server and
want to bring up the database in read-only mode between
restore operations, use the STANDBY clause of RESTORE
instead of the NORECOVERY clause.
"
Now when i implement this solution by first recovering
the database using NORECOVERY clause or STANDBY clause,
the database turns gray as (loading--in first case) and
(Read Only-- in second case), now it does not allow me to
restore any other database over this as it gives the
msg "The backup cannot be restored".
Please guide me for restoring the database successfully.
Thanks,
Amit
| |
|
| "Amit Kumar" <amitk@niit.com> wrote in news:14fc501c41cab$5afaaea0
$a001280a@phx.gbl:
> Dear support,
>
> Please help me with this problem.
>
> I am trying to restore the differential database backup
> on SQL 2000 server. When i restore, it throws following
> error
> "Error 4306
> Severity Level 16
> Message Text
> 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."
>
> I searched the standard solution for this error which
> states as follows:-
>
> "To recover a database, start the sequence over and use
> the NORECOVERY clause on all RESTORE statements except
> the last. If you are maintaining a standby server and
> want to bring up the database in read-only mode between
> restore operations, use the STANDBY clause of RESTORE
> instead of the NORECOVERY clause.
> "
>
> Now when i implement this solution by first recovering
> the database using NORECOVERY clause or STANDBY clause,
> the database turns gray as (loading--in first case) and
> (Read Only-- in second case), now it does not allow me to
> restore any other database over this as it gives the
> msg "The backup cannot be restored".
>
> Please guide me for restoring the database successfully.
>
> Thanks,
> Amit
>
from SQL BOL (I put in the parts in brackets):
Restore the most recent database backup. (with NORECOVERY)
Restore the last differential database backup. (with NORECOVERY or if
using this as final step don't use NORECOVERY)
Apply all transaction log backups created after the last differential
database backup was created if you use Full or Bulk-Logged Recovery
the point is that if you don't put in the NORECOVERY, SQL thinks your
done. with a differential you're not done and need to add in additional
restores
HTH
--
Neil
"you'd do what, to who, for how many biscuits?"
|
|
|
|
|