DB in suspended mode

Hi,

I have a database shown a SUSPENDED mode on both side of Principal and Mirror server. What should I do now?

1). Is the breaking the Mirror sesssion my only choice?

2). If I break it, how do I reestablish the Mirror again quickly. What is my potential data loss?

Thanks,

Hi Lin,

What happens when you issue "ALTER DATABASE <your db name> SET PARTNER RESUME" - does mirroring remain suspended?

Could you give some context about your setup and about why is database mirroring in the SUSPENDED mode in the first place - did some unrecoverable error happen or someone suspended it manually?

Thanks,

Kaloian.

|||Hi,

Mirroring has been paused.........resume the mirroring again.