Skip to Content
0
Former Member
Oct 29, 2013 at 01:24 PM

NORECOVERY MODE / STANDBY MODE?

359 Views

Hi,

Background:
Source Database A
Target Database B

1. Apply backup from System A to System B ( NORECOVERY MODE / STANDBY MODE)
2. Keep Database B in ( NORECOVERY MODE / STANDBY MODE)
3. Apply transactional logs everyday.
4. Continue applying Transactional logs for 15 days.
5. Recover database from ( NORECOVERY MODE / STANDBY MODE) after 15 days.

Question :- Which mode is better NORECOVERY MODE or STANDBY MODE for faster step 5? ( faster recovery ). Which one is recommended?

Regards,

Arpit.