March 19, 2010 at 4:51 am
Hi
We have enabled mirroring for some of the databases on our server.
There was a network outage, so we paused all the mirroring using the following sql
[highlight=#ffff11]alter database <Databasename> set partner suspend[/highlight]
Once the network issue was over we executed the following sql to bring it back to the normal state
[highlight=#ffff11]alter database <Databasename> set partner resume[/highlight]
All the databases came to normal state other than one. its still with the suspended state.
The size of the database is around 20gb so if we have to restart the mirroring we need to backitup and send it to the other location. which takes nearly 2 days.
Please advice how to bring this database to synchronized state. Awaiting for a reply
March 19, 2010 at 9:34 am
Depending on your activity level, it may simply be taking a while to re-synchronize. How long did you allow the command to run?
March 21, 2010 at 3:08 am
Hi
We already waited for long time.. nearly a day.. it is in pause state only.. we tried to resume it even using ssms. its going back to suspended state again. No idea whats going wrong.
May 10, 2010 at 9:30 am
I have the exact same issue. Hopefully someone will respond soon.
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply