Boris_FMPL
asked on
Sql Server 2008 mirroring problem
Hi
Some time ago I configured mirroring on several databases (between two servers Win 2003, Sql 2008)
Everything worked fine until now, on all databases I've got status Principal disconected / Mirror disconected). Both servers are up and running. There are only enabled buttons "Remove mirroring", "Configure security" and "Refresh" on mirroring properties.
How can I connect them again?
Regards
Some time ago I configured mirroring on several databases (between two servers Win 2003, Sql 2008)
Everything worked fine until now, on all databases I've got status Principal disconected / Mirror disconected). Both servers are up and running. There are only enabled buttons "Remove mirroring", "Configure security" and "Refresh" on mirroring properties.
How can I connect them again?
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ALTER DATABASE <database_name> SET PARTNER RESUME
Open in new window