<div>
This will get the status of the mirroring. Currently it is fine.<br />
But i'm looking for the reason/cause of this particular issue...
</div>


This will get the status of the mirroring. Currently it is fine.
But i'm looking for the reason/cause of this particular issue...

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
on secondary/ standby node we have following error messages, Not sure why we got these messages. The mirrored databse is in (Mirror, Synchronized/Restoring..).<wbr /> <br />
Could some one let me know the reason behind this and how to solve this issue from happening again.<br />
<br />
Error: 18272, Severity: 16, State: 1.<br />
Message<br />
During restore restart, an I/O error occurred on checkpoint file 'D:\MSSQL.1\MSSQL\Backup\t<wbr />est_db.CKP<wbr />' (operating system error 1784(The supplied user buffer is not valid for the requested operation.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.<br />
<br />
followed by<br />
<br />
Error: 1443, Severity: 16, State: 2.<br />
Message<br />
Database mirroring has been terminated for database 'test_db'. This is an informational message only. No user action is required.<br />
<br />
Finally logged with this message<br />
<br />
Message<br />
Database mirroring is active with database 'test_db' as the mirror copy. This is an informational message only. No user action is required.<br />
<br />
Also is there any way i can find the current status of the mirrored DB?<br />

</div>
</div>


Hi,

on secondary/ standby node we have following error messages, Not sure why we got these messages. The mirrored databse is in (Mirror, Synchronized/Restoring..). 
Could some one let me know the reason behind this and how to solve this issue from happening again.

Error: 18272, Severity: 16, State: 1.
Message
During restore restart, an I/O error occurred on checkpoint file 'D:\MSSQL.1\MSSQL\Backup\test_db.CKP' (operating system error 1784(The supplied user buffer is not valid for the requested operation.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.

followed by

Error: 1443, Severity: 16, State: 2.
Message
Database mirroring has been terminated for database 'test_db'. This is an informational message only. No user action is required.

Finally logged with this message

Message
Database mirroring is active with database 'test_db' as the mirror copy. This is an informational message only. No user action is required.

Also is there any way i can find the current status of the mirrored DB?


Mirroring Error on SQL Server 2k5

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.