Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Software Mirror on 11.9.2

5 posts in Windows NT Last posting was on 2000-06-02 13:28:49.0Z
Sybase Posted on 2000-05-20 13:51:21.0Z
From: "Sybase" <pschuman.NOSPAM@interserv.com>
Subject: Software Mirror on 11.9.2
Date: Sat, 20 May 2000 08:51:21 -0500
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <pw9XCOmw$GA.304@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207-229-173-35.d.enteract.com 207.229.173.35
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2144
Article PK: 1089574

I see the commands to use for establishing a software mirror.
disk mirror, disk unmirror, disk remirror, etc...

Is there a set of commands that display all device/database info
and show if any are running mirrors, and what the status of the mirror is
??
ie - primary, secondary active ?

Phil-


Eric McGrane Posted on 2000-05-22 13:42:49.0Z
Message-ID: <39293959.ADA89E0D@sybase.com>
Date: Mon, 22 May 2000 09:42:49 -0400
From: Eric McGrane <mcgrane@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Sybase <pschuman.NOSPAM@interserv.com>
Subject: Re: Software Mirror on 11.9.2
References: <pw9XCOmw$GA.304@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------611F9436737140C9DD91F2F2"
Newsgroups: sybase.public.sqlserver.nt
Lines: 30
NNTP-Posting-Host: mcgrane-nt.sybase.com 157.133.126.171
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2133
Article PK: 1089565

sp_helpdevice should do it for you.

E

Sybase wrote:

> I see the commands to use for establishing a software mirror.
> disk mirror, disk unmirror, disk remirror, etc...
>
> Is there a set of commands that display all device/database info
> and show if any are running mirrors, and what the status of the mirror is
> ??
> ie - primary, secondary active ?
>
> Phil-


Download VCard mcgrane.vcf


Phil Schuman Posted on 2000-05-22 18:02:45.0Z
From: "Phil Schuman" <pschuman.NOSPAM@interserv.com>
References: <pw9XCOmw$GA.304@forums.sybase.com> <39293959.ADA89E0D@sybase.com>
Subject: Re: Software Mirror on 11.9.2
Date: Mon, 22 May 2000 13:02:45 -0500
Lines: 20
Organization: Abacus Group
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <K#X03jBx$GA.289@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 216-80-34-37.d.enteract.com 216.80.34.37
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2127
Article PK: 1089558


Eric McGrane <mcgrane@sybase.com> wrote in message
news:39293959.ADA89E0D@sybase.com...
> sp_helpdevice should do it for you.
>

yup - thanks -
I had to make the "-w" really wide to see the results in a file.

For testing,
I created a mirror, then dropped the primary,
then did a re-mirror, then dropped the secondary
It now shows "mirror disabled", but still lists the file info.

Is there a way to really "drop the entire mirror definition" altogether ?

Phil -


Phil Schuman Posted on 2000-06-01 14:03:07.0Z
From: "Phil Schuman" <pschuman.NOSPAM@interserv.com>
References: <pw9XCOmw$GA.304@forums.sybase.com> <39293959.ADA89E0D@sybase.com> <K#X03jBx$GA.289@forums.sybase.com>
Subject: Software Mirror on 11.9.2
Date: Thu, 1 Jun 2000 09:03:07 -0500
Lines: 19
Organization: Abacus Group
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <ZnnhrM9y$GA.279@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt,sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.performance+tuning
NNTP-Posting-Host: 207-229-173-22.d.enteract.com 207.229.173.22
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:283 sybase.public.sqlserver.backup+recovery:1966 sybase.public.sqlserver.performance+tuning:208
Article PK: 1062476


> Eric McGrane <mcgrane@sybase.com> wrote in message
> news:39293959.ADA89E0D@sybase.com...

> > sp_helpdevice should do it for you.

> yup - thanks -
> I had to make the "-w" really wide to see the results in a file.
>

For testing,
I created a mirror, then dropped the primary,
then did a re-mirror, then dropped the secondary
It now shows "mirror disabled", but still lists the file info.

Is there a command to really "drop the entire mirror definition"
altogether ?

Phil -


Anthony Mandic <amandic Posted on 2000-06-02 13:28:49.0Z
Message-ID: <3937B691.9F814741@_start.com.au>
Date: Fri, 02 Jun 2000 23:28:49 +1000
From: Anthony Mandic <amandic@_start.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Software Mirror on 11.9.2
References: <pw9XCOmw$GA.304@forums.sybase.com> <39293959.ADA89E0D@sybase.com> <K#X03jBx$GA.289@forums.sybase.com> <ZnnhrM9y$GA.279@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt,sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.performance+tuning
Lines: 7
NNTP-Posting-Host: pix208a.magna.com.au 203.111.111.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:282 sybase.public.sqlserver.backup+recovery:1965 sybase.public.sqlserver.performance+tuning:207
Article PK: 1062475


Phil Schuman wrote:

> It now shows "mirror disabled", but still lists the file info.
>
> Is there a command to really "drop the entire mirror definition"
> altogether ?

It sounds like you called disk unmirror with mode = retain
rather than remove.

-am