What is Forced Service ?

 Posted by PandianS on 9/8/2010 | Category: Sql Server Interview questions | Views: 1924 | Points: 40

Database mirroring provides forcing service (with possible data loss) as a disaster recovery method to allow you to use a mirror server as a warm standby server.

Forcing service is possible only if the principal server is disconnected from the mirror server in a mirroring session. Because forcing service risks possible data loss, it should be used cautiously.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response