Hi, I am trying to take a differenctial backup on SQL server 2000 and restoring on the same server but different instance. When i am trying to take differential backup its showing error as
"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."
Please help me out uf anyone solved it before.