locked
SQL Server 2008 R2 mirroring problem RRS feed

  • Question

  • I have two Windows 2008 R2 (Amazon EC2) instances running SQL Server 2008 R2. I use 9TB striped disks (9x1TB EBS volumes) for storage. One server is running as principal and second one as mirror. Both started from the same image, database and tlog files located on striped disk. Mirror server failed 3 times in last 2 months with errors:

    EventID 823 
    The operating system returned error 2(The system cannot find the file specified.) to SQL Server during a write at offset 0x00000048058a00 in file 'D:\TLogs\*********_log.ldf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

    and

    EventID 1454
    Database mirroring will be suspended. Server instance 'xxxxxxxxxx' encountered error 823, state 6, severity 24 when it was acting as a mirroring partner for database '*********'. The database mirroring partners might try to recover automatically from the error and resume the mirroring session. For more information, view the error log for additional error messages.

    followed by

    EventID 19019
    The MSSQLSERVER service terminated unexpectedly.

    After this rebooting instance is necessary to restore mirroring.
    First two times I thought it was hardware related (striped disk failure) and relaunched instance on new hardware. But the issue is back after few weeks again. It only affects mirror instances. Any help would be really appreciated. Thanks.
    Tuesday, April 10, 2012 10:56 AM

Answers

  • Hi,

    A Windows write request has failed. This error is often the result of a hardware error, but may be caused by the device driver. For more information about error 823, see http://support.microsoft.com/kb/828339 . 

    I hope it helps.

    Janos


    There are 10 type of people. Those who understand binary and those who do not.
    My Blog

    • Marked as answer by andriusn Thursday, April 12, 2012 11:32 AM
    Tuesday, April 10, 2012 11:17 AM

All replies