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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.