FIX: Mirror Enabled After Losing Primary Device

• Microsoft SQL Server versions 6.0, 6.5

SYMPTOMS

The sp_helpdevice stored procedure shows that mirroring is enabled when the primary device has been lost.

WORKAROUND

Use Windows NT mirroring (Raid 1) instead of SQL Server mirroring, or check the SQL Server errorlog to determine if the primary device is online.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.0.

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

MORE INFORMATION

This is expected behavior of SQL Server. However, if the mirror device is lost, sp_helpdevice will properly show that mirroring is disabled.

Additional query words: prodsql raid winnt disk

Keywords          : kbprg SSrvStProc kbbug6.50 kbfix6.50.SP5 kbbug6.00 
Version           : WinNT:6.0,6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 21, 1999