Neither the partner nor the witness server instance for database is available

• manojkanoi

  SSCrazy

  Points: 2292

  More actions

  January 25, 2006 at 9:23 pm

  #113176

  I am getting this error while trying to setup mirroring.

  "Neither the partner nor the witness server instance for database "shop" is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)"

  I have used -T1400 as the startup parameter and tried setting this using the GUI as well SQL statements

  I did the backup and recovery based on this link http://msdn2.microsoft.com/en-us/library/ms189053.aspx and the mirror is in recovery mode now.

  I have tried fully qualified pathand ip for the servers also. I am not sure where I am going wrong. Please help.

• January 30, 2006 at 8:00 am

  This was removed by the editor as SPAM

• barsuk

  SSChampion

  Points: 12280

  More actions

  January 30, 2006 at 3:55 pm

  #617846

  I heard from 2 different MS specialists a recommendation not to use Mirroring untill it will be fixed with SP1 available in June.