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.
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.
Error: 1443, Severity: 16, State: 2.
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
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?