wpmann
asked on
SQL 2005 mirrored databases disconnected...
We setup mirroring and everything worked fine. The server with the backup database was relocated to a remote site on our WAN. It was offline a couple of days. I believe the server was just shutdown without pausing the mirror. Now, both ends say disconnected and I cannot get them to sync up. Both servers can talk to each other, the SQL management studio is able to open both SQL servers from either end.
I have tried alter database <db> set partner resume from both ends which had no affect.
Any suggestions?
I have tried alter database <db> set partner resume from both ends which had no affect.
Any suggestions?
I think you would need to setup the mirroing again by restoring the databases.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.