Link to home
Start Free TrialLog in
Avatar of wpmann
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?
Avatar of mikkilineni
mikkilineni

I think you would need to setup the mirroing again by restoring the databases.
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial