Mirroring Error on SQL Server 2k5

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?
parpaaAsked:
Who is Participating?
 
tpi007Commented:

Select
@@servername as Principal,db_name(database_id) as 'Mirror DB_Name',
case mirroring_state
When 0 then 'Suspended'
When 1 then 'Disconnected from other partner'
When 2 then 'Synchronizing'
When 3 then 'Pending Failover'
When 4 then 'Synchronized'
When null then 'Database is inaccesible or is not mirrored'
end as 'Mirroring_State',
case mirroring_role
When 1 then 'Principal'
When 2 then 'Mirror'
When null then 'Database is not mirrored or is inaccessible'
end as 'Mirroring_Role',
case mirroring_safety_level
When 0 then 'Unknown state'
When 1 then 'OFF (Asynchronous)'
When 2 then 'FULL (Synchronous)'
When null then 'Database is not mirrored or is inaccessible'
end as 'Mirror_Safety_Level',
Mirroring_Partner_Name as 'Mirror_Endpoint',
Mirroring_Partner_Instance as 'Mirror_ServerName',
Mirroring_Witness_Name as 'Witness_Endpoint',
Case Mirroring_Witness_State
When 0 then 'Unknown'
When 1 then 'Connected'
When 2 then 'Disconnected'
When null then 'Database is not mirrored or is inaccessible'
End as 'Witness_State',
Mirroring_Connection_Timeout as 'Failover Timeout in seconds',
Mirroring_Redo_Queue,
Mirroring_Redo_Queue_Type
from sys.Database_mirroring
where mirroring_role is not null
0
 
parpaaAuthor Commented:
This will get the status of the mirroring. Currently it is fine.
But i'm looking for the reason/cause of this particular issue...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.