Hi all,

Here is my scenario . I take full back up every friday and diffrential back up everday evening and transactional log every hour, If my system crashes suddenly. After restoring the full back up i need to restore the diffrential back up. After restoring the diffrential back it shows that the database is under loading. And its found unavailable for the appilaction. How can i over come that,

Mukesh

You will have to wait until that process finishes. does it stay in that state. Also are you restoring using with recovery? Each differential backup must be restored in sequence.

Follow the books online recommendation.

B. Restoring a database, differential database, and transaction log backup
This example restores a database, differential database, and transaction log backup of the MyNwind database.

-- Assume the database is lost at this point. Now restore the full
-- database. Specify the original full backup and NORECOVERY.
-- NORECOVERY allows subsequent restore operations to proceed.
RESTORE DATABASE MyNwind
   FROM MyNwind_1
   WITH NORECOVERY
GO
-- Now restore the differential database backup, the second backup on
-- the MyNwind_1 backup device.
RESTORE DATABASE MyNwind
   FROM MyNwind_1
   WITH FILE = 2,
      NORECOVERY
GO
-- Now restore each transaction log backup created after
-- the differential database backup.
RESTORE LOG MyNwind
   FROM MyNwind_log1
   WITH NORECOVERY
GO
RESTORE LOG MyNwind
   FROM MyNwind_log2
   WITH RECOVERY
GO



Jaime E. Maccou
Applications Analyst

Hi,

I suggest u to use Enterprise Manager for ease.

If u have recovered a full backup and then Deiff backup on that and still its shoeing that its getting loaded (Loading..) and grayed Use this one in Query Analyzer :-

RESTORE DATABASE MYDB RECOVERY

This should solve ur prob. If not then, delete the database and start recovery process. Seems u r aware of the NO Recovery / Standby option while restoring.

When u restore using Enterprise Maanger and restoring A Full backup, do remember to select the option "Leave database nonoperational but able to restore additional transaction log" in Options tab of dailog.
Then u restore the differential backup BUT DO REMEMBER to select "Leave database operational. NO additional transaction log can be restored" this time. Thats it.

Same applicable for restoring the transction log backups too if u r going for Point in time recovery.

Gud luck

B. Anant

Thank you very much for your prompt replies

I am was using with restore with recovery option. Now i understand that i should not have been done like that. Any way i will try with norecovery option. Thanks once again,

Mukesh