Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1160
  • Last Modified:

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.
0
motioneye
Asked:
motioneye
  • 2
1 Solution
 
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
 
imran_fastCommented:
check this table sys.dm_db_mirroring_connections
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now