sql2005 mirroring suspended

Hi,
sql2005 mirroring suddenly suspended, how do i go in details tp investigate the problem? I had try to resume the connection several time but end up with no success.
motioneyeAsked:
Who is Participating?
 
imran_fastConnect With a Mentor Commented:
check this table sys.dm_db_mirroring_connections
0
 
imran_fastCommented:

The database owner can resume a suspended database mirroring session, so make sure you are using the owner privellages.

To resume a database mirroring session
Connect to either partner.
Issue the following Transact-SQL statement:
ALTER DATABASE <database_name> SET PARTNER RESUME
where <database_name> is the mirrored database whose session you want to resume.

Regards
Imran
0
 
motioneyeAuthor Commented:
before go with this commands is there any sql statement that i can use to check on the mirroring availability and why it fail?
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.