Break mirror availability

I need to break a mirror on one of our reporting servers but it's 24/7 and
pretty busy. Does anyone know if this would interupt db access?
Thanks in advanceBy "break mirror", what do you mean exactly? Is it that you have RAID1 and
want to remove one of the disks? In that case, thee should be no
interruption. Just keep in mind that you are vulnerable until the
remirroring has been completed.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:9448F943-9543-4E51-BAB0-21AB10CA4B26@.microsoft.com...
I need to break a mirror on one of our reporting servers but it's 24/7 and
pretty busy. Does anyone know if this would interupt db access?
Thanks in advance|||Sorry Tom, my bad.
I'm mean database mirroring, not IO.
I want to break the mirror but I'm wondering if the primary will experience
any unavailability when I execute the SET PARTNER = NONE or whatever the
syntax is.
"Tom Moreau" wrote:

> By "break mirror", what do you mean exactly? Is it that you have RAID1 an
d
> want to remove one of the disks? In that case, thee should be no
> interruption. Just keep in mind that you are vulnerable until the
> remirroring has been completed.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
> news:9448F943-9543-4E51-BAB0-21AB10CA4B26@.microsoft.com...
> I need to break a mirror on one of our reporting servers but it's 24/7 and
> pretty busy. Does anyone know if this would interupt db access?
> Thanks in advance
>|||You can stop DB mirroring without affecting the principal. What you have to
do later depends on how mirroring was stopped. If you formally did an ALTER
database and told it that you don't want to mirror any more, then when you
do go to mirror again, you'll need to restore a full backup to the mirror
server and resynch. However, if all you did was take the mirror server
offline, then transactions will remain in the log of the primary until you
can get the mirror back online again.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:AD0CCDB5-2D7F-4FCE-94EA-28D814CA837D@.microsoft.com...
Sorry Tom, my bad.
I'm mean database mirroring, not IO.
I want to break the mirror but I'm wondering if the primary will experience
any unavailability when I execute the SET PARTNER = NONE or whatever the
syntax is.
"Tom Moreau" wrote:

> By "break mirror", what do you mean exactly? Is it that you have RAID1
> and
> want to remove one of the disks? In that case, thee should be no
> interruption. Just keep in mind that you are vulnerable until the
> remirroring has been completed.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
> news:9448F943-9543-4E51-BAB0-21AB10CA4B26@.microsoft.com...
> I need to break a mirror on one of our reporting servers but it's 24/7 and
> pretty busy. Does anyone know if this would interupt db access?
> Thanks in advance
>