March 13, 2006 at 2:27 am
Hi,
Can anyone explain me how the database on the secondary server is made
available to the users, when it is in read-only mode.
..hema
March 14, 2006 at 9:41 am
Hi, it depends on the recovery mode you specify when you set it up.
If you intend on using the shipped database on the secondary server once you have initiated failover, and the 'no recovery' option was specified in the plan, you will need to recover the database - ‘restore database databasename with recovery’
hth
March 15, 2006 at 11:23 pm
Actually , if possible take last transaction back up from the production server.
apply all transaction logs to the standby server in order with norecovery and apply last transaction backup to with recovery, so that the database restore is up to the failure point
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply